<div>
<div class="content wysiwyg-content">
How would you use PowerShell scripting to return general Windows Explorer metadata (Name, Size, Date Modified, Owner, etc.) from a file server for top level folders only. &nbsp;And would SQL Server 2008 PowerShell integration be able to link directly to the data to query the information? &nbsp;Thanks!
</div>
</div>


How would you use PowerShell scripting to return general Windows Explorer metadata (Name, Size, Date Modified, Owner, etc.) from a file server for top level folders only.  And would SQL Server 2008 PowerShell integration be able to link directly to the data to query the information?  Thanks!

Can PowerShell scripting return metadata for SQL Server to access?

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

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

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.