Month: July 2007

Which PCs are missing Hotfixes?

I was discussing with a friend how to determine the over all hot fix complicacy level, the other day, hence yesterday’s query. But what I wondering was why my test lab was not at 100% compliancy.  It will take a while for that to happen only because I have not rolled out IE 7 to […]

How to find your overall hot fix compliancy rate for servers only

Set Nocount OFF Declare @Installed as int Declare @Total as int Declare @Per as Float set @Installed = (SELECT SUM(CASE WHEN patch.Status0 = ‘Installed’ THEN 1 ELSE 0 END) as ‘Installed’  FROM  v_GS_PATCHSTATEEX  patch, v_GS_SYSTEM SYS where SYS.systemrole0 = ‘server’ and SYS.ResourceID = Patch.ResourceID) set @Total = (SELECT count(patch.Status0)FROM v_GS_PATCHSTATEEX  patch, v_GS_SYSTEM SYS where SYS.systemrole0 […]

Security on each object

SELECT  Distinct SecurityObjInstances.InstanceKey AS ‘object’, SecurityObjInstances.UserName, vSecurityClassPermissions.PermissionName FROM  SecurityObjInstances SecurityObjInstances, vSecurityClassPermissions vSecurityClassPermissions WHERE  vSecurityClassPermissions.ObjectKey = SecurityObjInstances.ObjectKey AND vSecurityClassPermissions.UserName = SecurityObjInstances.UserName ORDER BY SecurityObjInstances.InstanceKey, SecurityObjInstances.UserName, vSecurityClassPermissions.PermissionName  

Look who won partner of the year!

Information Worker Solutions, Office Systems Desktop Deployment Partner of the Year Winner • Compugen Richmond Hill, Canada The Information Worker Solutions, Office Systems Desktop Deployment Partner of the Year Award recognizes the exceptional partner that has excelled in offering breakthrough Microsoft Office system solutions. The winning partner’s technology and marketing offerings have increased its customers’ […]