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

0 Votes

Versioning - This is an older 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

ID2994624
StatusAlpha - Code that was just developed
TitleMSSQL
DomainBESC
Added by on 1/20/2014 2:47:20 PM
Last Modified by on 1/20/2014 2:47:20 PM
Counters 846 Views / 1 Download
User Rating 1 star 2 star 3 star 4 star 5 star * Average over 0 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)

Relevance

isWindows (Relevance 1172)
Used in 1107 fixlets and 524 analyses   * Results in a true/false
Show indented relevance
windows of operating system
Windows XP or later (Relevance 2996958)
Used in 20 fixlets and 9 analyses   * Results in a true/false
Show indented relevance
version of operating system >= "5.1"
Used in 2 analyses   * Results in a true/false
Show indented relevance
exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer" of native registry
Used in 2 analyses   * Results in a true/false
Show indented relevance
exists key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL" of native registry

Sharing

Social Media:
Share this page on Yammer

Comments

Log In or Register to leave comments!
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