SQL Query Template
| 1 Votes |
Description
Property Details
| 640 | |
| SQL Query Template | |
| BESC | |
| Common Tasks | |
| 0 | |
| danielheth@bigfix.me | |
| <Unspecified> | |
| <Unspecified> | |
| 10/26/2012 12:00:00 AM | |
| MSSQL | |
| True | |
| danielheth on 10/26/2012 11:59:35 AM | |
| danielheth on 10/26/2012 11:59:35 AM | |
| 7625 Views / 47 Downloads | |
* Average over 0 ratings.
** Log In or Register to add your rating.
|
Relevance
isWindows (Relevance 274)
name of operating system starts with "Win"
| Used in 1 fixlet | * Results in a true/false |
(( exists key whose (value "DisplayName" of it as string contains "Microsoft SQL Server 2000" AND value "DisplayVersion" of it as string as version = "8") of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall" of registry) AND NOT exists key "HKLM\SOFTWARE\Microsoft\MSSQLServer" whose (NOT exists key whose (name of it != "Client") of it) of registry) OR (disjunction of (exists key whose (exists key "Setup" whose (exists value "Edition" of it AND (value "Version" of it as string as version = "9" OR value "Version" of it as string as version = "10") AND value "Edition" of it != "Express Edition") of it ) of keys "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server" of ((if x64 of operating system then x64 registry else nothing) ; registry)))
Actions
Action 1 (default)
Action Link Click
here to deploy this action.
Script Type
BigFix Action Script
delete __appendfile
appendfile set nocount on
appendfile select name from sys.databases where name = 'pubs' or name = 'Northwind'
delete statement.sql
move __appendfile statement.sql
waithidden sqlcmd -E -n -w 1200 -W -h-1 -s "~" -i statement.sql -o "{(pathname of parent folder of client)}\sql_result.txt" -b
Success Criteria
This action will be considered successful when the applicability relevance evaluates to false.
Sharing
| Social Media: |
