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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "6.0.300" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java(TM) 6%"
Count Adobe Reader versions
SELECT DISTINCT TOP (100) PERCENT DisplayName0, Version0, COUNT(Version0) AS Total FROM dbo.v_GS_ADD_REMOVE_PROGRAMS GROUP BY DisplayName0, Version0 HAVING (DisplayName0 LIKE ‘%Adobe Reader%’) ORDER BY Total DESC, DisplayName0
Collections with computers without Forefront Endpoint Protection 2010 client
A customer asked me today to help him with creating some collections with client computers that do not have FEP 2010 installed so he can advertise the antivirus client to those computers. You can find the queries bellow. All Windows 7 without Forefront Endpoint Protection 2010 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 … Continue reading Collections with computers without Forefront Endpoint Protection 2010 client
Create a report to count all computer models and manufacturer for computers inside a specific collection
SELECT dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 AS Manufacturer, dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, COUNT(dbo.v_GS_COMPUTER_SYSTEM.Model0) AS Total FROM dbo.v_GS_COMPUTER_SYSTEM INNER JOIN dbo.v_FullCollectionMembership ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_FullCollectionMembership.ResourceID GROUP BY dbo.v_GS_COMPUTER_SYSTEM.Model0, dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0, dbo.v_FullCollectionMembership.CollectionID HAVING (dbo.v_FullCollectionMembership.CollectionID = 'CollectionID’) ORDER BY Total DESC, Manufacturer, Model
I’ve been at Tech-Ed today…
Actually I just attended a local event organized by Microsoft Romania and the last session was Useful Hacker Techniques: Which Part of Hackers' Knowledge Will Help You in Efficient IT Administration held by polish Enterprise Security MVP - Paula Januszkiewicz. Geez… this girl presented some things that, I can bet, made half of all admins … Continue reading I’ve been at Tech-Ed today…
Installing Forefront Endpoint Protection 2010 RC – prerequisite error
While installing the latest “Forefront Client Security” product named Forefront Endpoint Protection 2010 (RC version), the prerequisites verification step displayed an error at the “Verifying restart is not required” step. And the error details: “An earlier software installation still has outstanding file rename operations pending. Before Setup can continue, you must restart the computer.” The … Continue reading Installing Forefront Endpoint Protection 2010 RC – prerequisite error
Install SQL Server on a 64 bit Windows Server–missing SQLncli_x64.msi
I had to install a copy of SQL Server 2005 on a Windows Server 2003 R2 SP2 x64. During installation I got a strange error saying that SQLncli_x64.msi file is missing. I was pretty sure that I have the same ISO file as I did while installing SQL so many times before and without any … Continue reading Install SQL Server on a 64 bit Windows Server–missing SQLncli_x64.msi
Installing Configuration Manager v.Next
Prerequisites configured before starting the installation: Windows Server 2008 R2 updated Active Directory Domain Services Installing Central Administration Site (CAS): Installing Primary Site:
Distribute Adobe Flash Player
If you need to create a ConfigMgr software package with Adobe Flash Player and want to use it’s .msi file, you can find this file at the following address: http://www.adobe.com/products/flashplayer/fp_distribution3.html Please note that in order to distribute Adobe Flash Player you need to have a valid Adobe Flash Player Distribution License Agreement in place. For … Continue reading Distribute Adobe Flash Player
Report with computer models and manufacturers
SELECT TOP (100) PERCENT Manufacturer0 AS Manufacturer, Model0 AS Model, COUNT(Model0) AS Total FROM dbo.v_GS_COMPUTER_SYSTEM GROUP BY Model0, Manufacturer0 ORDER BY Total DESC, Manufacturer, Model