Can we get information for SQL database instances

July 24, 2019 at 7:00 AM

Can we get report of all SQL database instances snow shows information about sql server application installed in each system but can we get information about SQL DB that has been created. If see Oracle enterprise report it clearly shows you DB instance name like database name that has been created using Oracle Database Enterprise edition. Can we get similar information for SQL DB instances also? ‌ ‌ ‌ ‌

carolai
7 years ago
Hi Kiran, At least Snow Inventory Agent seems to collect some db information and send it to Snow Inventory. As Martin wrote unfortunately you cannot find it directly in Snow License Manager. But if you only would like to see the database instance name without any further information you can use as workaround the CIDC report. This is the report Microsoft wanted to have in the last years to do audits. You can find that report in group Microsoft -> Clean Inventory Data Contract (CIDC) - Excel export only This report takes some time and is only available as Excel export in Report files. This Excel consists of 8 sheets and in sheet F you can see the computer name, installed SQL Server version and also the "SQL Server Instance Name".. Perhaps that may help you a bit.
Expand Post
- Portal User
  7 years ago
  Great addition Carola, I must admit I was unaware of that the instance was included in this report! Thank you!
  Expand Post
Portal User
7 years ago
Hi Kiran. No, unfortunately this is not possible out of the box. The reason you sometimes see Oracle DB instances but not SQL instances in License Manager is that there is an optional Oracle scan made for Oracle databases that queries the Oracle DB directly for information like instances, users, features etc. This is a java addition to the inventory agent that can be requested for Oracle server installations. SQL Server on the other hand is recognized by the same method as all other applications, by finding the executable, the running process and some key registry entries. This is not enough to provide instance names or MSSQL features. There is currently no similar "extra info" script for MSSQL. You might be able to work around this by a custom script that can query some additional information from the SQL server, and put that in a custom field in the License Manager application though. You could ask the Snow professional services team if they have a solution ready for this too. Best regards Martin
Expand Post