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
Month: June 2010
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 enabled · Pinged the server · Mapped a […]
SELECT [AdvertisementID] ,[AdvertisementName] ,[ProgramFlags] ,[PackageID] ,[ProgramName] ,[CollectionID] ,[PresentTime] ,[TimeFlags] ,[ExpirationTime] ,[AdvertisementSourceSite] ,[PackageName] ,[PackageVersion] ,[PackageLanguage] ,[PackageManufacturer] ,[CollectionName] FROM [dbo].[v_AdvertisementInfo] where (0x00001000 & Programflags) != 0
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)’
“Dear Secure Certificate Customer, Thank you for contacting Secure Certficate Support. It appears as though this is a common issue when installing the .spc file to Internet Explorer (IE) 8. Once installed the private is marked as not exportable. You may wish to try and rekey and reinstall the certificate to a Firefox browser. Firefox […]
CTE has done it again!! The are giving away 140, 000 worth of Training for ITIL and Win2k8 Boot Camp! Here are the details! Hi Garth, This summer CTE Solutions, will again, be giving away over $140,000 worth of free training and certification programs to help the unemployed technology professionals in our region. We […]
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 […]
select R.Name, OS.Caption, OS.CSDVersion from SMS_R_System R inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId where OS.CSDVersion is null and OS.Caption like “%Vista%”
select SYS.Netbios_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath From v_GS_SoftwareFile SF join v_R_System SYS on SYS.ResourceID = SF.ResourceID Where SF.FileName = ‘OUTLOOK.EXE’ AND FILEPATH LIKE ‘%\Microsoft Office\OFFICE%’ ORDER BY SYS.Netbios_Name0
Select CS.Name0, OS.Caption0, OS.CSDversion0 From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID Where OS.Caption0 like ‘%Vista%’ and OS.CSDversion0 is Null