OWSUG.ca

select *  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 like "TTDR___AC__W___"

So, my test lab has been running lean and mean for a while. A few weeks back I decided that in order to test ConfigMgr v.Next. I needed to update my lab. In the past I had a few discussion about Hyper-v and getting more performance out of it.   The summary of the tips are: ...

select Distinct     CS.Name0 from     dbo.v_GS_COMPUTER_SYSTEM CS     left outer join dbo.v_GS_SoftwareFile SF on CS.ResourceID = SF.ResourceID where     SF.ResourceID not in (select Distinct ResourceID from dbo.v_GS_SoftwareFile where FileName = ...

select * from dbo.v_GS_NETWORK_ADAPTER_CONFIGUR where IPAddress0 IS not NULL and IPAddress0 like '192.168.[1-9].%'

I have decided that the forums on www.SMSUG.ca are not being used and due to some SPAMMER populating the membership list, I have closed them down. This is a good thing as it means I will arrange for the site to be convert to a blog only site. With the new site will come a new look a feel. (wait for it)   If you are looking ...

I was troubling shooting a WSUS issue and I need to connect to the db to edit some settings. This turns out to be harder than you think when you using Windows Internal db. So how do you connect to the db? Well this post will answer that for you. http://www.mssqltips.com/tip.asp?tip=1577

Today I was trying to use the Remote Assistance from ConfigMgr, I keep getting a error message Your Offer to help could not be sent see screen shot below     Of course I did the normal troubleshooting stuff. ·        Check the GPO to ensure it was ...

SELECT  [AdvertisementID]       ,[AdvertisementName] ,[ProgramFlags]       ,[PackageID]       ,[ProgramName]       ,[CollectionID]       ,[PresentTime]       ...

Select distinct     TopConsoleUser0 from     dbo.v_Add_Remove_Programs ARP     Join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on ARP.ResourceId = SCUM.ResourceID Where     ARP.DisplayName0 = 'Update for Windows Server 2003 (KB923845)'

Here is a nice and simple way to get a list of Random PCs.   Create a query based on what you want to find, in my example Windows XP. Then add to the query a condition to find those with a “3” as the last character in the SMSID, Since the SMSID/GUID is HEX this will give you ~1/16 of all of those ...