Kitaab

Faced an issue when we created the Service Level Dashboard in SCOM 2012 As SLD can be created in the SCOM console in 2012 version of it , i went ahead and created a Distributed Application , then associated Service level monitoring with it. Finally i went ahead and created the SLD from SCOM Console. However once the dashboard was created it did not show any data. The Image is shown here: As i was checking online i found a thread on technet forum: http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/def9592c-0de6-47e5-9312-5a5fbbc8df34 Accordingly i checked the Data Warehouse Synchronization Server Discovered Inventory in our case. It was empty. Image as shown: Ran the Powershell Script given in the technet forum: #Note: change these values appropriately $OperationalDbSqlServerInstance = "SDOHHQDBA107.mog.maerskoil.com" $OperationalDbDatabaseName = "OperationsManager" $DataWarehouseSqlServerInstance = "SDOHH

Facing issue with Citrix EdgeSight Server not showing License Trending Usage : As we can see from the Image there was no data from 8th Sept 2012 . When looking into the license details i found somehow the license detail is not updated . Checked the core_lsm_license_poller log  08/09/2012 13:34:42: LicenseServerMonitor: OnTimer: end  08/09/2012 13:49:43: LicenseServerMonitor: OnTimer: begin  08/09/2012 13:49:43: LicenseServerMonitor: PollLicenseServers: begin  08/09/2012 13:49:43: LicenseServerMonitor: PollLicenseServers method invoked *********************************  08/09/2012 13:49:43: LicenseServerMonitor: Begin polling Server LIcServr01 on port 27000  08/09/2012 13:49:43: LicenseServerMonitor: Total Polling Time: 00:00.35  08/09/2012 13:49:43: LicenseServerMonitor: Polling Successful. Total Licenses Retrieved: 13  08/09/2012 13:49:43: LicenseServerMonitor: PollLicenseServers method completed. *******************************  08/09/2012 13:49:4

We had a requirement to monitor the the output of a Query (Stored Procedure in our case) and the Alert based on the result it generated. In Our case we wanted to monitor something like SELECT statusno from XXX table  If statusno > 0 alert = OK Else Alert = fail End if So it was like If the Output is anything but 0 we wanted an alert. I referenced these 2 articles to create our Script based Monitor http://systemcenter.no/?p=190 http://www.systemcentercentral.com/downloads/downloadsdetails/tabid/144/indexid/7362/default.aspx I faced some issues where in the script gave errors and did not execute correctly. The Script i used and that worked for us is a slight modification of one listed here  http://systemcenter.no/?p=190  to suit our requirement. ****************************************************************************** Dim objCN, strConnection Dim objAPI, oBag Set objCN = CreateObject("ADODB.Connection") Set objAPI = CreateObject("MOM.Scr