Audit de SharePoint sans outils

01/09/2014
Comment faire un audit d’un environnement SharePoint quand on ne dispose pas d’outil ?
On peut trouver sur codeplex des outils comme SharePoint Farm Poster ou Inventory Tool qui proposent des bonnes idées. Mais pour être plus adaptée aux besoins des environnements, il faudra utiliser PowerShell, Visio, Excel et de l’huile de coude.
Benjamin Niaulin a écrit un article permettant de créer un inventaire de SharePoint. Le script PowerShell permet de créer un fichier CSV contenant les données de l’environnement SharePoint. Puis on utilise l’assistant organigramme de Visio pour créer une hiérarchie à partie du CSV.
Comment ajouter du sens à cet organigramme pour aider à gérer l’environnement ?
Visio propose une fonctionnalité nommée Graphique de données (Data graphic en anglais) qui permet d’afficher des indicateurs en fonction des valeurs. Cela peut se traduire visuellement par l’ajout d’une vignette, d’une icône ou d’une couleur.
[][1]
Parmi les informations facilement accessibles :
La taille de la collection de site
Le pourcentage de remplissage d’une collection de site
RequestAccessEmail
La dernière utilisation
Le nombre de contribution au newsfeed
Le nombre de liste
Le nombre d’utilisateurs
Astuce 1 : Comment sélectionner des objects/propriétés qui n’existent pas avec Select-Object ?
Select-Object Title, Url, {$_.Lists.Count}, @{Name="Size (Recursive)"; Expression = {GetWebSizes -StartWeb $_.URL }}</pre>

Astuce 2 : Comment afficher facilement une barre de progression dans un script Powershell? En utilisant la commande [Write-Progress][2]

<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-powershell" data-lang="powershell">$webapp.Sites | Get-SPWeb -Limit All | Select-Object Title [<span style="color:#960050;background-color:#1e0010">…</span>]|
%{
    Write-Progress -Id 3 -Activity <span style="color:#e6db74">&#39;Processing web &#39;</span> -Status $_.Url -PercentComplete (($idxWebs / $nbWebs) * 100)
    $idxWebs++
} | Export-Csv [...]&lt;/pre&gt;

Phil Childs propose un script pour connaitre la taille d<span style="color:#960050;background-color:#1e0010">’</span>un SPWeb de manière récursive qui se montre très utile.

On peut ensuite créer des indicateurs en fonction des valeurs. Les captures ci-dessous montrent un indicateur basé sur le ratio d<span style="color:#960050;background-color:#1e0010">’</span>utilisation du quota et le rendu.

[&lt;img class=<span style="color:#e6db74">&#34;alignnone size-full wp-image-227&#34;</span> src=<span style="color:#e6db74">&#34;/wp-content/uploads/2014/09/visio-ratio.png?fit=622%2C470&#34;</span> alt=<span style="color:#e6db74">&#34;Visio-Ratio&#34;</span> srcset=<span style="color:#e6db74">&#34;/wp-content/uploads/2014/09/visio-ratio.png?resize=300%2C227 300w, /wp-content/uploads/2014/09/visio-ratio.png?w=622 622w&#34;</span> sizes=<span style="color:#e6db74">&#34;(max-width: 622px) 100vw, 622px&#34;</span> data-recalc-dims=<span style="color:#e6db74">&#34;1&#34;</span> /&gt;][3]

Ensuite, il reste à trouver des indicateurs pertinents par rapport à l<span style="color:#960050;background-color:#1e0010">’</span>utilisation de l<span style="color:#960050;background-color:#1e0010">’</span>environnement que l<span style="color:#960050;background-color:#1e0010">’</span>on peut faire ressortir dans Excel <span style="color:#960050;background-color:#1e0010">:</span>

  * les créations de sites dans le temps
  * la répartition entre les différents modèles de site
  * la durée d<span style="color:#960050;background-color:#1e0010">’</span>utilisation moyenne d<span style="color:#960050;background-color:#1e0010">’</span>un site

[&lt;img class=<span style="color:#e6db74">&#34;alignnone size-full wp-image-228&#34;</span> src=<span style="color:#e6db74">&#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?fit=515%2C277&#34;</span> alt=<span style="color:#e6db74">&#34;Excel-SiteCreation.xlsx&#34;</span> srcset=<span style="color:#e6db74">&#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?resize=300%2C161 300w, /wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?w=515 515w&#34;</span> sizes=<span style="color:#e6db74">&#34;(max-width: 515px) 100vw, 515px&#34;</span> data-recalc-dims=<span style="color:#e6db74">&#34;1&#34;</span> /&gt;][4]

Comme vous le voyez, il est possible de tirer des informations de SharePoint sans outils. Mais la méthode McGyver a ses limites et le besoin de s<span style="color:#960050;background-color:#1e0010">’</span>outiller se fait rapidement sentir. Cela sera l<span style="color:#960050;background-color:#1e0010">’</span>occasion d<span style="color:#960050;background-color:#1e0010">’</span>un article futur.

**Références<span style="color:#960050;background-color:#1e0010">:</span>**

[Benjamin Niaulin <span style="color:#960050;background-color:#1e0010">–</span> how to build an inventory before SharePoint migration][5]

[Phil Childs <span style="color:#960050;background-color:#1e0010">–</span> Check size of SharePoint 2010 sites][6]

[Comment faire un audit d<span style="color:#960050;background-color:#1e0010">’</span>un environnement SharePoint quand on ne dispose pas d<span style="color:#960050;background-color:#1e0010">’</span>outil ?

On peut trouver sur codeplex des outils comme SharePoint Farm Poster ou Inventory Tool qui proposent des bonnes idées. Mais pour être plus adaptée aux besoins des environnements, il faudra utiliser PowerShell, Visio, Excel et de l<span style="color:#960050;background-color:#1e0010">’</span>huile de coude.

Benjamin Niaulin a écrit un article permettant de créer un inventaire de SharePoint. Le script PowerShell permet de créer un fichier CSV contenant les données de l<span style="color:#960050;background-color:#1e0010">’</span>environnement SharePoint. Puis on utilise l<span style="color:#960050;background-color:#1e0010">’</span>assistant organigramme de Visio pour créer une hiérarchie à partie du CSV.

Comment ajouter du sens à cet organigramme pour aider à gérer l<span style="color:#960050;background-color:#1e0010">’</span>environnement ?

Visio propose une fonctionnalité nommée Graphique de données (Data graphic en anglais) qui permet d<span style="color:#960050;background-color:#1e0010">’</span>afficher des indicateurs en fonction des valeurs. Cela peut se traduire visuellement par l<span style="color:#960050;background-color:#1e0010">’</span>ajout d<span style="color:#960050;background-color:#1e0010">’</span>une vignette, d<span style="color:#960050;background-color:#1e0010">’</span>une icône ou d<span style="color:#960050;background-color:#1e0010">’</span>une couleur.

[&lt;img class=<span style="color:#e6db74">&#34;alignnone size-full wp-image-226&#34;</span> src=<span style="color:#e6db74">&#34;/wp-content/uploads/2014/09/visio-extract.png?fit=326%2C168&#34;</span> alt=<span style="color:#e6db74">&#34;Visio-extract&#34;</span> srcset=<span style="color:#e6db74">&#34;/wp-content/uploads/2014/09/visio-extract.png?resize=300%2C155 300w, /wp-content/uploads/2014/09/visio-extract.png?w=326 326w&#34;</span> sizes=<span style="color:#e6db74">&#34;(max-width: 326px) 100vw, 326px&#34;</span> data-recalc-dims=<span style="color:#e6db74">&#34;1&#34;</span> /&gt;][1]

Parmi les informations facilement accessibles <span style="color:#960050;background-color:#1e0010">:</span>

  * La taille de la collection de site
  * Le pourcentage de remplissage d<span style="color:#960050;background-color:#1e0010">’</span>une collection de site
  * RequestAccessEmail
  * La dernière utilisation
  * Le nombre de contribution au newsfeed
  * Le nombre de liste
  * Le nombre d<span style="color:#960050;background-color:#1e0010">’</span>utilisateurs

Astuce 1 <span style="color:#960050;background-color:#1e0010">:</span> Comment sélectionner des objects/propriétés qui n<span style="color:#960050;background-color:#1e0010">’</span>existent pas avec Select-Object ?

&lt;div class=<span style="color:#e6db74">&#34;highlight&#34;</span>&gt;&lt;pre style=<span style="color:#e6db74">&#34;color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4&#34;</span>&gt;&lt;code class=<span style="color:#e6db74">&#34;language-powershell&#34;</span> data-lang=<span style="color:#e6db74">&#34;powershell&#34;</span>&gt;Select-Object Title, Url, {$_.Lists.Count}, @{Name=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;Size (Recursive)&amp;#34;&lt;/span&gt;; Expression = {GetWebSizes -StartWeb $_.URL }}&amp;lt;/pre&amp;gt;</span>

Astuce 2 &lt;span style=<span style="color:#e6db74">&#34;color:#960050;background-color:#1e0010&#34;</span>&gt;<span style="color:#960050;background-color:#1e0010">:</span>&lt;/span&gt; Comment afficher facilement une barre de progression dans un script Powershell? En utilisant la commande [Write-Progress][2]

&amp;lt;div class=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;highlight&amp;#34;&lt;/span&gt;&amp;gt;&amp;lt;pre style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4&amp;#34;&lt;/span&gt;&amp;gt;&amp;lt;code class=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;language-powershell&amp;#34;&lt;/span&gt; data-lang=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;powershell&amp;#34;&lt;/span&gt;&amp;gt;$webapp.Sites | Get-SPWeb -Limit All | Select-Object Title [&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;…&lt;/span&gt;&amp;lt;/span&amp;gt;]|</span>
%{
    Write-Progress -Id 3 -Activity &amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#39;Processing web &amp;amp;#39;&amp;lt;/span&amp;gt; -Status $_.Url -PercentComplete (($idxWebs / $nbWebs) * 100)&lt;/span&gt;</span>
    $idxWebs++
} | Export-Csv [...]&amp;amp;lt;/pre&amp;amp;gt;

Phil Childs propose un script pour connaitre la taille d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;un SPWeb de manière récursive qui se montre très utile.</span>

On peut ensuite créer des indicateurs en fonction des valeurs. Les captures ci-dessous montrent un indicateur basé sur le ratio d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;utilisation du quota et le rendu.</span>

[&amp;amp;lt;img class=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;alignnone size-full wp-image-227&amp;amp;#34;&amp;lt;/span&amp;gt; src=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;/wp-content/uploads/2014/09/visio-ratio.png?fit=622%2C470&amp;amp;#34;&amp;lt;/span&amp;gt; alt=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;Visio-Ratio&amp;amp;#34;&amp;lt;/span&amp;gt; srcset=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;/wp-content/uploads/2014/09/visio-ratio.png?resize=300%2C227 300w, /wp-content/uploads/2014/09/visio-ratio.png?w=622 622w&amp;amp;#34;&amp;lt;/span&amp;gt; sizes=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;(max-width: 622px) 100vw, 622px&amp;amp;#34;&amp;lt;/span&amp;gt; data-recalc-dims=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;1&amp;amp;#34;&amp;lt;/span&amp;gt; /&amp;amp;gt;][3]&lt;/span&gt;</span>

Ensuite, il reste à trouver des indicateurs pertinents par rapport à l&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;utilisation de l&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;environnement que l&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;on peut faire ressortir dans Excel &amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;:&lt;/span&gt;&amp;lt;/span&amp;gt;</span>

  * les créations de sites dans le temps
  * la répartition entre les différents modèles de site
  * la durée d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;utilisation moyenne d&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;un site</span>

[&amp;amp;lt;img class=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;alignnone size-full wp-image-228&amp;amp;#34;&amp;lt;/span&amp;gt; src=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?fit=515%2C277&amp;amp;#34;&amp;lt;/span&amp;gt; alt=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;Excel-SiteCreation.xlsx&amp;amp;#34;&amp;lt;/span&amp;gt; srcset=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?resize=300%2C161 300w, /wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?w=515 515w&amp;amp;#34;&amp;lt;/span&amp;gt; sizes=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;(max-width: 515px) 100vw, 515px&amp;amp;#34;&amp;lt;/span&amp;gt; data-recalc-dims=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;1&amp;amp;#34;&amp;lt;/span&amp;gt; /&amp;amp;gt;][4]&lt;/span&gt;</span>

Comme vous le voyez, il est possible de tirer des informations de SharePoint sans outils. Mais la méthode McGyver a ses limites et le besoin de s&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;outiller se fait rapidement sentir. Cela sera l&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;occasion d&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;un article futur.</span>

**Références&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;:&lt;/span&gt;&amp;lt;/span&amp;gt;**</span>

[Benjamin Niaulin &amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;–&lt;/span&gt;&amp;lt;/span&amp;gt; how to build an inventory before SharePoint migration][5]</span>

[Phil Childs &amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;–&lt;/span&gt;&amp;lt;/span&amp;gt; Check size of SharePoint 2010 sites][6]</span>

](http&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;:&lt;/span&gt;&amp;lt;/span&amp;gt;//spposter.codeplex.com/)</span>

[Comment faire un audit d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;un environnement SharePoint quand on ne dispose pas d&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;outil ?</span>

On peut trouver sur codeplex des outils comme SharePoint Farm Poster ou Inventory Tool qui proposent des bonnes idées. Mais pour être plus adaptée aux besoins des environnements, il faudra utiliser PowerShell, Visio, Excel et de l&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;huile de coude.</span>

Benjamin Niaulin a écrit un article permettant de créer un inventaire de SharePoint. Le script PowerShell permet de créer un fichier CSV contenant les données de l&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;environnement SharePoint. Puis on utilise l&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;assistant organigramme de Visio pour créer une hiérarchie à partie du CSV.</span>

Comment ajouter du sens à cet organigramme pour aider à gérer l&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;environnement ?</span>

Visio propose une fonctionnalité nommée Graphique de données (Data graphic en anglais) qui permet d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;afficher des indicateurs en fonction des valeurs. Cela peut se traduire visuellement par l&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;ajout d&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;une vignette, d&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;une icône ou d&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;une couleur.</span>

[&amp;amp;lt;img class=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;alignnone size-full wp-image-226&amp;amp;#34;&amp;lt;/span&amp;gt; src=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;/wp-content/uploads/2014/09/visio-extract.png?fit=326%2C168&amp;amp;#34;&amp;lt;/span&amp;gt; alt=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;Visio-extract&amp;amp;#34;&amp;lt;/span&amp;gt; srcset=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;/wp-content/uploads/2014/09/visio-extract.png?resize=300%2C155 300w, /wp-content/uploads/2014/09/visio-extract.png?w=326 326w&amp;amp;#34;&amp;lt;/span&amp;gt; sizes=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;(max-width: 326px) 100vw, 326px&amp;amp;#34;&amp;lt;/span&amp;gt; data-recalc-dims=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;1&amp;amp;#34;&amp;lt;/span&amp;gt; /&amp;amp;gt;][1]&lt;/span&gt;</span>

Parmi les informations facilement accessibles &amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;:&lt;/span&gt;&amp;lt;/span&amp;gt;</span>

  * La taille de la collection de site
  * Le pourcentage de remplissage d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;une collection de site</span>
  * RequestAccessEmail
  * La dernière utilisation
  * Le nombre de contribution au newsfeed
  * Le nombre de liste
  * Le nombre d&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;utilisateurs</span>

Astuce 1 &amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;:&lt;/span&gt;&amp;lt;/span&amp;gt; Comment sélectionner des objects/propriétés qui n&amp;lt;span style=&lt;span style=&#34;color:#e6db74&#34;&gt;&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&lt;/span&gt;&amp;gt;&lt;span style=&#34;color:#960050;background-color:#1e0010&#34;&gt;’&lt;/span&gt;&amp;lt;/span&amp;gt;existent pas avec Select-Object ?</span>

&amp;amp;lt;div class=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;highlight&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;lt;pre style=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;lt;code class=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;language-powershell&amp;amp;#34;&amp;lt;/span&amp;gt; data-lang=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;powershell&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;Select-Object Title, Url, {$_.Lists.Count}, @{Name=&amp;amp;lt;span style=&amp;lt;span style=&amp;#34;color:#e6db74&amp;#34;&amp;gt;&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;Size (Recursive)&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;; Expression = {GetWebSizes -StartWeb $_.URL }}&amp;amp;amp;lt;/pre&amp;amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Astuce 2 &amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;lt;span style=&amp;#34;color:#960050;background-color:#1e0010&amp;#34;&amp;gt;:&amp;lt;/span&amp;gt;&amp;amp;lt;/span&amp;amp;gt; Comment afficher facilement une barre de progression dans un script Powershell? En utilisant la commande [Write-Progress][2]&lt;/span&gt;</span>

&amp;amp;amp;lt;div class=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;highlight&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;lt;pre style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;lt;code class=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;language-powershell&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt; data-lang=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;powershell&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;$webapp.Sites | Get-SPWeb -Limit All | Select-Object Title [&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;…&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;]|&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
%{
    Write-Progress -Id 3 -Activity &amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#39;Processing web &amp;amp;amp;amp;#39;&amp;amp;amp;lt;/span&amp;amp;amp;gt; -Status $_.Url -PercentComplete (($idxWebs / $nbWebs) * 100)&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
    $idxWebs++
} | Export-Csv [...]&amp;amp;amp;amp;lt;/pre&amp;amp;amp;amp;gt;

Phil Childs propose un script pour connaitre la taille d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;un SPWeb de manière récursive qui se montre très utile.&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

On peut ensuite créer des indicateurs en fonction des valeurs. Les captures ci-dessous montrent un indicateur basé sur le ratio d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;utilisation du quota et le rendu.&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[&amp;amp;amp;amp;lt;img class=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;alignnone size-full wp-image-227&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; src=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/visio-ratio.png?fit=622%2C470&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; alt=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;Visio-Ratio&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; srcset=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/visio-ratio.png?resize=300%2C227 300w, /wp-content/uploads/2014/09/visio-ratio.png?w=622 622w&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; sizes=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;(max-width: 622px) 100vw, 622px&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; data-recalc-dims=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;1&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; /&amp;amp;amp;amp;gt;][3]&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Ensuite, il reste à trouver des indicateurs pertinents par rapport à l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;utilisation de l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;environnement que l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;on peut faire ressortir dans Excel &amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;:&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

  * les créations de sites dans le temps
  * la répartition entre les différents modèles de site
  * la durée d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;utilisation moyenne d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;un site&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[&amp;amp;amp;amp;lt;img class=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;alignnone size-full wp-image-228&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; src=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?fit=515%2C277&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; alt=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;Excel-SiteCreation.xlsx&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; srcset=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?resize=300%2C161 300w, /wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?w=515 515w&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; sizes=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;(max-width: 515px) 100vw, 515px&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; data-recalc-dims=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;1&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; /&amp;amp;amp;amp;gt;][4]&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Comme vous le voyez, il est possible de tirer des informations de SharePoint sans outils. Mais la méthode McGyver a ses limites et le besoin de s&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;outiller se fait rapidement sentir. Cela sera l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;occasion d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;un article futur.&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

**Références&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;:&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;**&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[Benjamin Niaulin &amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;–&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt; how to build an inventory before SharePoint migration][5]&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[Phil Childs &amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;–&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt; Check size of SharePoint 2010 sites][6]&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[Comment faire un audit d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;un environnement SharePoint quand on ne dispose pas d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;outil ?&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

On peut trouver sur codeplex des outils comme SharePoint Farm Poster ou Inventory Tool qui proposent des bonnes idées. Mais pour être plus adaptée aux besoins des environnements, il faudra utiliser PowerShell, Visio, Excel et de l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;huile de coude.&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Benjamin Niaulin a écrit un article permettant de créer un inventaire de SharePoint. Le script PowerShell permet de créer un fichier CSV contenant les données de l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;environnement SharePoint. Puis on utilise l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;assistant organigramme de Visio pour créer une hiérarchie à partie du CSV.&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Comment ajouter du sens à cet organigramme pour aider à gérer l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;environnement ?&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Visio propose une fonctionnalité nommée Graphique de données (Data graphic en anglais) qui permet d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;afficher des indicateurs en fonction des valeurs. Cela peut se traduire visuellement par l&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;ajout d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;une vignette, d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;une icône ou d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;une couleur.&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[&amp;amp;amp;amp;lt;img class=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;alignnone size-full wp-image-226&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; src=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/visio-extract.png?fit=326%2C168&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; alt=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;Visio-extract&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; srcset=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/visio-extract.png?resize=300%2C155 300w, /wp-content/uploads/2014/09/visio-extract.png?w=326 326w&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; sizes=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;(max-width: 326px) 100vw, 326px&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; data-recalc-dims=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;1&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; /&amp;amp;amp;amp;gt;][1]&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Parmi les informations facilement accessibles &amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;:&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

  * La taille de la collection de site
  * Le pourcentage de remplissage d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;une collection de site&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
  * RequestAccessEmail
  * La dernière utilisation
  * Le nombre de contribution au newsfeed
  * Le nombre de liste
  * Le nombre d&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;utilisateurs&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Astuce 1 &amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;:&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt; Comment sélectionner des objects/propriétés qui n&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;amp;#34;color:#e6db74&amp;amp;#34;&amp;amp;gt;&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;lt;span style=&amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;#34;&amp;amp;gt;’&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;existent pas avec Select-Object ?&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

&amp;amp;amp;amp;lt;div class=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;highlight&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;pre style=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;code class=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;language-powershell&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt; data-lang=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;powershell&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;Select-Object Title, Url, {$_.Lists.Count}, @{Name=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;amp;gt;&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;Size (Recursive)&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;; Expression = {GetWebSizes -StartWeb $_.URL }}&amp;amp;amp;amp;amp;lt;/pre&amp;amp;amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Astuce 2 &amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;#34;&amp;amp;amp;gt;:&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt; Comment afficher facilement une barre de progression dans un script Powershell? En utilisant la commande [Write-Progress][2]&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

&amp;amp;amp;amp;amp;lt;div class=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;highlight&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;pre style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;code class=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;language-powershell&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt; data-lang=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;powershell&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;$webapp.Sites | Get-SPWeb -Limit All | Select-Object Title [&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;…&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;]|&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
%{
    Write-Progress -Id 3 -Activity &amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#75715e&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;#39;Processing web &amp;amp;amp;amp;amp;amp;#39;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; -Status $_.Url -PercentComplete (($idxWebs / $nbWebs) * 100)&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
    $idxWebs++
} | Export-Csv [...]&amp;amp;amp;amp;amp;amp;lt;/pre&amp;amp;amp;amp;amp;amp;gt;

Phil Childs propose un script pour connaitre la taille d&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;un SPWeb de manière récursive qui se montre très utile.&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

On peut ensuite créer des indicateurs en fonction des valeurs. Les captures ci-dessous montrent un indicateur basé sur le ratio d&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;utilisation du quota et le rendu.&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[&amp;amp;amp;amp;amp;amp;lt;img class=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#75715e&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;#34;alignnone size-full wp-image-227&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; src=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/visio-ratio.png?fit=622%2C470&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; alt=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;Visio-Ratio&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; srcset=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/visio-ratio.png?resize=300%2C227 300w, /wp-content/uploads/2014/09/visio-ratio.png?w=622 622w&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; sizes=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;(max-width: 622px) 100vw, 622px&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; data-recalc-dims=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;1&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; /&amp;amp;amp;amp;amp;amp;gt;][3]&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Ensuite, il reste à trouver des indicateurs pertinents par rapport à l&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;utilisation de l&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;environnement que l&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;on peut faire ressortir dans Excel &amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

  * les créations de sites dans le temps
  * la répartition entre les différents modèles de site
  * la durée d&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;utilisation moyenne d&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;un site&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[&amp;amp;amp;amp;amp;amp;lt;img class=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#75715e&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;#34;alignnone size-full wp-image-228&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; src=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?fit=515%2C277&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; alt=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;Excel-SiteCreation.xlsx&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; srcset=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;/wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?resize=300%2C161 300w, /wp-content/uploads/2014/09/excel-sitecreation-xlsx.png?w=515 515w&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; sizes=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;(max-width: 515px) 100vw, 515px&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; data-recalc-dims=&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;#34;1&amp;amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; /&amp;amp;amp;amp;amp;amp;gt;][4]&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

Comme vous le voyez, il est possible de tirer des informations de SharePoint sans outils. Mais la méthode McGyver a ses limites et le besoin de s&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;outiller se fait rapidement sentir. Cela sera l&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;occasion d&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;’&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;un article futur.&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

**Références&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;**&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[Benjamin Niaulin &amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;–&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; how to build an inventory before SharePoint migration][5]&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

[Phil Childs &amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;–&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; Check size of SharePoint 2010 sites][6]&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

](http&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;//spposter.codeplex.com/)&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

](https&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;//sharepointinventory.codeplex.com/)&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>

 [1]&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; /wp-content/uploads/2014/09/visio-extract.png&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
 [2]&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; http&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;//technet.microsoft.com/en-us/library/hh849902.aspx&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
 [3]&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; /wp-content/uploads/2014/09/visio-ratio.png&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
 [4]&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; /wp-content/uploads/2014/09/excel-sitecreation-xlsx.png&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
 [5]&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; http&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;//en.share-gate.com/blog/how-to-build-an-inventory-before-sharepoint-migration&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;lt;/span&amp;gt;&lt;/span&gt;</span>
 [6]&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;lt;span style=&amp;amp;lt;span style=&amp;lt;span style=&lt;span style=<span style="color:#e6db74">&#34;color:#e6db74&#34;</span>&gt;&amp;<span style="color:#75715e">#34;color:#e6db74&amp;#34;&lt;/span&gt;&amp;gt;&amp;amp;&lt;span style=&#34;color:#75715e&#34;&gt;#34;color:#e6db74&amp;amp;#34;&amp;lt;/span&amp;gt;&amp;amp;gt;&amp;amp;amp;&amp;lt;span style=&amp;#34;color:#75715e&amp;#34;&amp;gt;#34;color:#e6db74&amp;amp;amp;#34;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;amp;gt;&amp;amp;amp;amp;&amp;amp;lt;span style=&amp;amp;#34;color:#75715e&amp;amp;#34;&amp;amp;gt;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;&amp;amp;amp;lt;span style=&amp;amp;amp;#34;color:#75715e&amp;amp;amp;#34;&amp;amp;amp;gt;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt; http&amp;amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#e6db74&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;amp;#34;&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;span style=&amp;amp;amp;amp;#34;color:#960050;background-color:#1e0010&amp;amp;amp;amp;#34;&amp;amp;amp;amp;gt;:&amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;gt;//get-spscripts.com/2010/08/check-size-of-sharepoint-2010-sites.html&amp;amp;amp;amp;amp;lt;/code&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/pre&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;lt;/div&amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;/code&amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;/pre&amp;amp;amp;amp;gt;&amp;amp;amp;amp;lt;/div&amp;amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;/code&amp;amp;amp;gt;&amp;amp;amp;lt;/pre&amp;amp;amp;gt;&amp;amp;amp;lt;/div&amp;amp;amp;gt;&amp;amp;lt;/span&amp;amp;gt;&amp;amp;lt;/code&amp;amp;gt;&amp;amp;lt;/pre&amp;amp;gt;&amp;amp;lt;/div&amp;amp;gt;&amp;lt;/span&amp;gt;&amp;lt;/code&amp;gt;&amp;lt;/pre&amp;gt;&amp;lt;/div&amp;gt;&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;</span></code></pre></div>