What field in the SQL database is the OS stored?
I'm looking to create a query that gives me a list of all servers that have their OS set as "Linux".
All Comments (3)
Mark,
the OS is stored in the dbo.connections table in your DB. You can run a query like the one below and replace "databasename" with the name of your database.
Felix
SELECT DISTINCT
DATA, ConnectionType, GroupName, Name, MetaData, CreationDate, ModifiedDate, ModifiedUsername
FROM [databasename].dbo.Connections
Where DATA like '%Linux%'
Neat, thanks. Get a quick complete listing of all the servers that need bash fixes.. :P
No problem at all, happy fixing!