Relevance/Fixlet to get MS SQL Instance and Size info

Content Authoring
1

I’ve had a request from some of our users to report on the MS SQL Instances and sizes on computers where SQL Server has been installed.

Many of these users are running a Developer version of the database, so this is not necessarily a situation where we can just run a SQL query and is likely something we need to do more at the file level. I’ve been told that for getting the storage information, it’s acceptable for us just to get the sizes of the files with extensions mdf, ldf, and ndf.

Has anyone tried to produce a similar report? Any previous posts out here, or content on BigFix.me that may be helpful?

2

Take a look at the “local mssql” inspector: https://developer.bigfix.com/relevance/reference/local-mssql-database.html
Here are a couple of examples I have just run on one of my test system:

Q: running of local mssql database
A: True

Q: instance name of local mssql database
A: MSSQLSERVER

In general if you need to generate a report, then you can create a set of “properties” that returns the wanted mssql information

3 Likes