Here are example commands to use the command line for creating blackouts for database objects:
Host:
./fglcmd.sh –srv fms.example.com -port 8080 -usr foglight -pwd foglight -cmd topology:blackoutobject -query "Host where name='host1.example.com' " -schedulename Always -inheritable
SQL Server database instance:
./fglcmd.sh –srv fms.example.com -port 8080 -usr foglight -pwd foglight -cmd topology:blackoutobject -query "DBSS_Instance where name='MYSQLINSTANCE' " -schedulename Always -inheritable
Oracle database instance:
./fglcmd.sh -usr foglight -pwd foglight -cmd topology:blackoutobject -query "DBO_Instance where name='MYORACLEINSTANCE' " -schedulename Always -inheritable
Database groups:
./fglcmd.sh –srv fms.example.com -port 8080 -usr foglight -pwd foglight -cmd topology:blackoutobject -query "DBWC_GV_GroupIdentifier where name='testgroup' " -schedulename Always -inheritable
- For each alarm, we can check the "isBlackedOut" property of the source topology object to confirm whether it is indeed in blackout state