The Cloudamize software uses a PowerShell script to collect Basic and Advanced MS SQL data from the server.

Only the Agentless Data Collector requires PowerShell 2.0 on the remote host to collect the Basic MS SQL Data. However, Windows Agent does not use a PowerShell script to collect the Basic MS SQL data. The Agent-based data collection will almost always get the basic MS SQL data successfully without using a PowerShell script.

To collect the Advanced MS SQL Data from the server, Agentless and Agent both require PowerShell 5.1 or higher.

Data

Agent

Agentless

Basic SQL DATA Collected

·       SQL server instance ID

✔

✔

·       SQL server instance name

✔

✔

·       SQL server edition

✔

✔

·       SQL server version

✔

✔

·       SQL server patch level

✔

✔

·       SQL server service pack

✔

✔

·       SQL server bin path

✔

✔

·       SQL server data path

✔

✔

·       SQL server error log file

✔

✔

·       Database name: master, model. 

✔

✔

·       Database size in MB

✔

✔

·       Database name and its size info

✔

✔

·       Core licenses text

✔

✔

·       Cluster name

✔

✔

·       Cluster state (If the SQL server belongs to the cluster or Not)

✔

✔

·       SQL server Status (if Server is active in the cluster)

✔

✔

·       SQL cluster owner host name

✔

✔

·       SQL server feature list

✔

✔

·       SQL server product info

✔

✔

·       SQL server uses HADR (High Availability and Disaster Recovery)

✔

✔

·       SQL server filestream enable level

✔

✔

·       Is Fulltext installed

✔

✔

·       Is Polybase installed

✔

✔

·       Collation content

✔

✔

Advanced SQL DATA Collected

·       Cluster Quorum Type

✔

✔

·       PerfMon Mode

✔

✔

·       Availability Group Name

✔

✔

·       Availability Group Primary Replica Server Name

✔

✔

·       Availability Group Local Replica Role

✔

✔

·       Local Availability Group Replica Server Primary

✔

✔

·       Availability Group Replicas

✔

✔

·       Linked Server (Is sever a Linked server)

✔

✔

·       Command Shell Status (Enabled/Disabled)

✔

✔

·       SQL CLR Status (Common Language Runtime (CLR) integration is enabled or not) 

✔

✔

·       Encryption Status (Enabled/Disabled)

✔

✔

·       Database Mirroring Status (Enabled/Disabled)

✔

✔

·       Database Replication Status (Enabled/ Disabled)

✔

✔

·       Maximum server memory

✔

✔

·       Number of databases

✔

✔

·       Total database size 

✔

✔

·       Availability Group Readable Secondary (Description of secondary role connections)

✔

✔

·       Availability Group Synchronous Replication (The availability mode of the replica, (Asynchronous/ Synchronous/ Configuration only))

✔

✔

·       Availability Group Failover Mode (Description of failover mode)

✔

✔