Basic and Advanced MS SQL data collected by Agents and Agentless Data Collectors
What is it?
Cloudamize can collect two types of Microsoft (MS) SQL data: Basic data and Advanced data. The Basic data includes much of the critical MS SQL data. Customers who want additional MS SQL data will want to capture the advanced data as well (this can be helpful for detailed SQL licensing analysis). More information about what is included in the Basic data and Advanced data can be found in the table below.
How does it work?
The Cloudamize software uses a PowerShell script to collect Basic and Advanced MS SQL data from servers. The Cloudamize agent (Windows) will almost always capture Basic MS SQL data successfully without using a PowerShell script. To collect the Advanced MS SQL data from the server, the Agent (and Agentless) both require PowerShell 5.1 or higher.
If using the Agentless Data Collector, PowerShell 2.0 or higher must be installed on the remote host for Cloudamize to collect the Basic MS SQL Data. To collect the Advanced MS SQL Data from the server, PowerShell 5.1 or higher must be installed on the remote host.
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) | ✔ | ✔ |