MSSQL
| 6 Votes |
Versioning - This is the latest version.
Description
Some info about MS SQL
The latest version of this analysis can be found here: http://bigfix.me/analysis/details/2994623
Property Details
Properties
SQLPath
Period
2 days
| * Results in a true/false |
value "SQLPath" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup" of native registry
CurrentVersion
Period
2 days
| * Results in a true/false |
value "CurrentVersion" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion" of native registry
Instance Names
Period
2 days
| * Results in a true/false |
values "MSSQLSERVER" of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry
DefaultData Location
Period
2 days
| * Results in a true/false |
values "DefaultData" of keys "MSSQLServer" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry
DefaultLog Location
Period
2 days
| * Results in a true/false |
values "DefaultLog" of keys "MSSQLServer" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry
SQLDataRoot
Period
2 days
| * Results in a true/false |
values "SQLDataRoot" of keys "Setup" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry
Patch Level
Period
1 day
| * Results in a true/false |
values "PatchLevel" of keys "Setup" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry
Edition
Period
7 days
| * Results in a true/false |
unique values of (((it as string) of values "Edition" of keys "Setup" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry);((it as string) of values "EditionType" of keys "Setup" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry))
DBs
Period
1 day
| * Results in a true/false |
names of files whose(name of it as lowercase ends with ".mdf") of ((folders "DATA" of folders ((it as string) of values "SQLDataRoot" of keys "Setup" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry)) ; folders ((it as string) of values "DefaultData" of keys "MSSQLServer" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry))
DB_Transaction_Logs
Period
1 day
| * Results in a true/false |
names of files whose(name of it as lowercase ends with ".ldf") of ((folders "DATA" of folders ((it as string) of values "SQLDataRoot" of keys "Setup" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry)) ; folders ((it as string) of values "DefaultLog" of keys "MSSQLServer" of keys ((it as string) of value "MSSQLSERVER" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry))
BackupDirectory
Period
1 day
| * Results in a true/false |
values "BackupDirectory" of keys "MSSQLServer" of keys ((it as string) of values "MSSQLSERVER" of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry
Backups
Period
1 day
| * Results in a true/false |
names of files of folders ((it as string) of values "BackupDirectory" of keys "MSSQLServer" of keys ((it as string) of values "MSSQLSERVER" of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" of native registry)
InstanceRegKey?
Period
12 hours
| * Results in a true/false |
(exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry)
MSSQLServer RegKey?
Period
12 hours
| * Results in a true/false |
(exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer" of native registry)
Running? Rel
Period
12 hours
| * Results in a true/false |
exists runnings whose(it = TRUE) of local mssql databases
Relevance
Windows Only (Relevance 2997197)
/* Windows Only */ windows of operating system
| Used in 1 analsis | * Results in a true/false |
/* Windows 2003 or later */ version of operating system >= "5.1"
| Used in 1 analsis | * Results in a true/false |
/* MSSQL */ (exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry) OR (exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer" of native registry) OR ((exists local mssql databases) AND (exists runnings whose(it = TRUE) of local mssql databases))
Sharing
| Social Media: |
Comments
 |
|
| Is there an update or another version of this analysis that includes a fix for non-default instances of SQL? | |
 |
|
| Hi thetick, could you send me the updated code that works for non-default instance names? I'm getting same issue as well. Thanks | |
 |
|
| Messaging me privately through the BigFix Forums is probably the best option. | |
 |
|
| Hi James. Thanks for this analysis, it worked very well :) I added some changes to it as this one hard codes the default instance (which worked on my test system, but not a customer system) and I would like to send it to you to review. I do not see an ability to add it here and I do not want to post a duplicate. What is the best way to get it to you? Thanks Martin | |
