IT Professional

Albert Widjaja

Enterprise Solutions Architect

Software Squirrel

<div>
Not what I was looking for but it will get the results I need without any performance changes. &nbsp;This way accesses the Web Object first. It gives the same information and not improvements. But it will get information.
</div>


<div>
May be of interest:<br><br><a href="https://blog.netwrix.com/2018/11/12/most-useful-sharepoint-powershell-commands/" rel="ugc">https://blog.netwrix.com/2018/11/12/most-useful-sharepoint-powershell-commands/</a>&nbsp;<br><br><a href="https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/?view=sharepoint-ps" rel="ugc">https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/?view=sharepoint-ps</a>&nbsp;
</div>


<div>
Thanks, not perfect but hope is helps you some.
</div>


<div>
<div class="content wysiwyg-content">
I am trying to get information for a very large number of site collections. I only need information like Title, URL, Size. I can accomplish this with the site collection object model by looping through every site collection in the content database. It takes way too many resources and time to perform that query. &nbsp;Is there another way to get that information more efficiently without accessing the database directly (which is off the table)?
</div>
</div>


I am trying to get information for a very large number of site collections. I only need information like Title, URL, Size. I can accomplish this with the site collection object model by looping through every site collection in the content database. It takes way too many resources and time to perform that query.  Is there another way to get that information more efficiently without accessing the database directly (which is off the table)?

Access Information for a Very Large Number of Sites

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).