I have had few conservation with MS about the AI catalog recently about, What I’m using it for, why is it important, how the catalog is update and when, etc… Here is what you need to know. MS requires 4 different site to upload an application before it will be categories It takes 30 days […]
Month: March 2011
Ok Everyone, it is time to tell MS what you think a stem Center Configuration Manager 2012 and System Center Operations Manager 2012. http://borntolearn.mslearn.net/btl/b/weblog/archive/2011/03/24/system-center-folks-we-need-your-input.aspx 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 […]
Here is what the booth looked like yesterday at noon. Great booth layout! at 3:30, looking better!
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 = “192.168.1.1”
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”
What a cool app! To quote their website. http://www.myallyapps.com/ “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 […]
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%’
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