MSSQL
Log In or Register to download the BES file, and more.

4 Votes

Versioning - This is the latest version.

1MSSQL1/20/2014 2:27:05 PM
2MSSQL1/20/2014 2:47:20 PM
3MSSQL1/30/2014 8:30:15 AM

Description

Some info about MS SQL

 

The latest version of this analysis can be found here:  http://bigfix.me/analysis/details/2994623


Property Details

ID2994632
StatusAlpha - Code that was just developed
TitleMSSQL
DomainBESC
Added by on 1/30/2014 8:30:15 AM
Last Modified by on 1/30/2014 8:30:15 AM
Counters 8928 Views / 165 Downloads
User Rating 1 star 2 star 3 star 4 star 5 star * Average over 4 ratings. ** Log In or Register to add your rating.

Properties

SQLPath
Period 2 days
 
  * Results in a true/false
Show indented relevance
value "SQLPath" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup" of native registry
CurrentVersion
Period 2 days
 
  * Results in a true/false
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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
Show indented relevance
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)
instance names
Period 12 hours
 
  * Results in a true/false
Show indented relevance
instance names of local mssql databases
Running?
Period 12 hours
 
  * Results in a true/false
Show indented relevance
runnings of local mssql databases
InstanceRegKey?
Period 12 hours
 
  * Results in a true/false
Show indented relevance
(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
Show indented relevance
(exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer" of native registry)
Running? Rel
Period 12 hours
 
  * Results in a true/false
Show indented relevance
exists runnings whose(it = TRUE) of local mssql databases

Relevance

Windows Only (Relevance 2997197)
Used in 6450 fixlets and 32 analyses   * Results in a true/false
Show indented relevance
/* Windows Only */ windows of operating system
Used in 1 analsis   * Results in a true/false
Show indented relevance
/* Windows 2003 or later */ version of operating system >= "5.1"
Used in 1 analsis   * Results in a true/false
Show indented relevance
/* 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:
Share this page on Yammer

Comments

Log In or Register to leave comments!
DSBF3327 -
Is there an update or another version of this analysis that includes a fix for non-default instances of SQL?
eeldivad -
Hi thetick, could you send me the updated code that works for non-default instance names? I'm getting same issue as well. Thanks
jgstew -
Messaging me privately through the BigFix Forums is probably the best option.
thetick -
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