Skip to main content

Posts

SCCM collection Query for machines without citrix client

Needed to make a SCCM collection for machines that do not have Citrix Client / receiver installed. After a lot of modifications there is what my final wql - query looked like (Sub -Select) select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System  inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId  where SMS_G_System_COMPUTER_SYSTEM.Name not in  (select distinct SMS_G_System_COMPUTER_SYSTEM.Name  from SMS_R_System  inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId  inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId  where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like  " Citrix Online plug-in %") We can utilize this query to crea...

Windows Scheduled task Management pack

While Implementing monitoring for Schedule tasks with SCOM 2012 , we utilized a community management pack http://rburri.wordpress.com/2008/02/14/windows-scheduled-tasks-management-pack-for-opsmgr-2007/ After we imported the MP , we started receiving a lot of alerts related to some tasks which no one knew about . It was a schedule task related to User profile manager software that we had tested. We wanted to delete this schedule task on all the machines that raised the alert In order to find the machines , we used the following SQL query against Opsmgr db SELECT  MonitoringObjectPath,MonitoringObjectName, AlertStringName, AlertStringDescription, MonitoringRuleId, Name FROM Alertview WITH (NOLOCK) WHERE TimeRaised is not NULL AND AlertStringName like 'Scheduled Task failed to complete successfully' And MonitoringObjectName like '\updater.exe' Then i created a batch file with the following content schtasks /delete /F /TN "updater.exe" wher...

SCOM 2012 SP1 Web Application Monitoring

Noticed a strange behavior with new SCOM 2012 SP1 Web Application transaction and Availability Monitoring If we create a Web Application monitor for internal websites without the FQDN it doesn't work. e.g if we try and create the Web Application monitor to monitor : http://ourwebsite it Fails However http://ourwebsite.domain.com Works In SCOM 2007 R2 ,we dint face this issue. Maybe a Bug of somekind Hope this helps

SCCM Collection for computes with Java version 7

We needed to uninstall Java 7 from Machines.For that we created a collection based on product ID instead of Display Name in Add Remove programs. This collection query will include all machines that have 32-bit or 64-bit Java Installed select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductCode like "{26a24ae4-039d-4ca4-87b4-2f832170%" or SMS_G_System_INSTALLED_SOFTWARE.ProductCode like "{26A24AE4-039D-4CA4-87B4-2F864170%" We can then uninstall the products using a SCCM create a package to run this script: You may need to add more products depending on other versions that you have installed for Java for me we only had java 7  update 3 , 4 7, 9 ,10 strComputer = "...

WMI Error: 424 Object required The processing of Group Policy failed. Windows could not evaluate the Windows Management Instrumentation (WMI) filter for the Group Policy object

Sometimes on the Citrix Xenapp servers (which are based on windows 2008 R2  RDS) , we face WMI issues which we get notified by users trying to Launch applications and getting errors: When we check the %temp% folder for the user on the server where they are launching the apps from we see the log file for Logon Script showing entries like Error: 424 Object required Machine details 27-11-2012 10:31:46 0 (0x0000) The detected IP (Computer is Unreachable!) is not the expected value, switching to alternate IP discovery method Machine details 27-11-2012 10:31:46 0 (0x0000) Also you may see the event 1065 in System Event log on the Server. The processing of Group Policy failed. Windows could not evaluate the Windows Management Instrumentation (WMI) filter for the Group Policy object  When we try to connect to WMI , we see error as shown. Basic Steps: -Ensure that the Windows Management Instrumentation (WMI) service is runni...

SCOM 2012 Service Level Dashboard SLD Empty

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...

CItrix Edgesight not showing Updated License information

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. **************...