Skip to main content

Posts

Showing posts from January, 2013

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 create collection for any softwar

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 = "