Get Collation text, statustxt details from MSSQL DB through discovery pattern

[Rutuja K]

Hello,

I want to fetch Collation text, statustxt details from MSSQL DB through discovery pattern. These are metadata values and cannot be accessed by WMI. What is the other way to discover these details

Thank You!

[Kieran Anson]

You should be able to run a query via the sqlcmd cmdlet.

sqlcmd -S <server_name> -d <database_name> -U <username> -P <password> -Q "SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation') AS Collation;"

[Rutuja K]

Hello @Kieran Anson 

Thank you for the response.

I am new to discovery patterns. Could you explain how to run query via sqlcmd cmdlet please

Do I need to add any step in pattern or create new probes/sensors?

[Kieran Anson]

Modifying patterns requires indepth knowledge. I'd recommend taking the NowLearning course (it's free)

[BasantChauhan]

Hi @Kieran Anson ,

Can you please tell name of the course that will cover concepts like modifying patterns and making new ones?