Month – March 2011

70-243 & 70-242 – Call to Action!

Ok Everyone, it is time to tell MS what you think a stem Center Configuration Manager 2012 and System Center Operations Manager 2012. The Survey is 5 questions lone with the most “taxing” question being “What are the top 10 tasks that a ConfigMgr should be able to perform?” I’m sure that there are […]

Collection by Gateway

select     SMS_R_System.Name from      SMS_R_System     inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where     SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DefaultIPGateway = “”

Client Version and model

select     SMS_R_System.Name,     SMS_R_System.ResourceId,     SMS_G_System_COMPUTER_SYSTEM.Manufacturer,     SMS_G_System_COMPUTER_SYSTEM.Model from      SMS_R_System     inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where     SMS_R_System.ClientVersion = “4.00.6487.2000”     and SMS_G_System_COMPUTER_SYSTEM.Model = “Virtual Machine”

Cool App – nightally

What a cool app! To quote their website. “nightally™ lets you to size up the situation, distract and disarm a potential attacker or get the attention of bystanders (anyone near by) and get to a safe place—before something happens. Simply click nightally™ to activate it before you leave home or work. Should a problem […]

SQL using Installed Software

SELECT         S.Name0,     S.SystemRole0,     S.SystemType0,     S.Domain0,     INSO.ARPDisplayName0 FROM             v_GS_INSTALLED_SOFTWARE INSO     INNER JOIN v_GS_SYSTEM S ON INSO.ResourceID = S.ResourceID where     ARPDisplayName0 like ‘%SQL%’ 

Query Logic

SELECT SYS.Netbios_Name0, SF.FileName, SF.FileSize/1024/1024 AS ‘Size, KB’, SF.FilePath FROM dbo.v_GS_SoftwareFile AS SF INNER JOIN dbo.v_R_System AS SYS ON SYS.ResourceID = SF.ResourceID where (SF.FileName LIKE ‘%.pdf’ AND SF.FilePath LIKE ‘%My Documents%’) OR (SF.FileName LIKE ‘%.pdf’ AND SF.FilePath LIKE ‘%Desktop%’) OR (SF.FileName LIKE ‘%.pdf’ AND SF.FilePath LIKE ‘%C:\%’) and SF.FileSize>1024 ORDER BY SYS.Netbios_Name0