Add Component: SQL
| 0 Votes |
Collections (part of 1 collection)
Description
Configure BigFix Dashboard Backend Service to execute a "SQL" statement as part of this component.
The statement is executed against the specified SQL server regularly.
Property Details
| 751 | |
| Add Component: SQL | |
| BES | |
| Common Tasks | |
| 0 | |
| danielheth@bigfix.me | |
| <Unspecified> | |
| <Unspecified> | |
| 12/6/2012 12:00:00 AM | |
| BigFix Dashboard | |
| True | |
| danielheth on 12/6/2012 6:22:17 PM | |
| danielheth on 12/6/2012 6:22:17 PM | |
| 4325 Views / 66 Downloads | |
* Average over 0 ratings.
** Log In or Register to add your rating.
|
Relevance
is Windows but not Mobile (Relevance 606)
| Used in 560 fixlets | * Results in a true/false |
if( name of operating system starts with "Win" ) then platform id of operating system != 3 else false
Not in Proxy Agent Context (Relevance 1131)
if exists property "in proxy agent context" then ( not in proxy agent context ) else true
Actions
Action 1 (default)
Action Link Click
here to add this component.
Script Type
BigFix Action Script
action parameter query "Title" with description "Enter the Friendly Name:" and with default value "My Root Service"
action parameter query "Category" with description "Enter the sorting category (ex: general, service or other):" and with default value "other"
action parameter query "Desc" with description "Enter a description that will be set to clients:" and with default value "This is my sql cmd that returns..."
action parameter query "SQLCmd" with description "Enter the SQL Command that should be executed:" and with default value "SELECT count(1) FROM sys.databases"
action parameter query "SQLServer" with description "Enter the SQL Server hostname that will execute the cmd:" and with default value "sql.domain.local"
action parameter query "Interval" with description "Enter the check interval in milliseconds (default: 900000 or 15min):" and with default value "900000"
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" ""="sql"
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" "Title"="{parameter "Title"}"
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" "Category"="{parameter "Category"}"
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" "Desc"="{parameter "Desc"}"
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" "SQLCmd"="{parameter "SQLCmd"}"
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" "SQLServer"="{parameter "SQLServer"}"
if {parameter "Interval" != "900000"}
regset "[HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Dashboard\Settings\Service {parameter "Title"}]" "Interval"="{parameter "Interval"}"
endif
Success Criteria
This action will be considered successful when the applicability relevance evaluates to false.
Sharing
| Social Media: |
