Client Management Suite

I've checked some machines and see the following screenshot: wee have 200 licenses witch have already been reached. (212 machines)  In the process of buying another 100 licenses. Surely this wouldn't stop the hotfixes being install on the machines.

http://yfrog.com/ju46123236p
 

Hi Joe,

As per my understanding you should be getting this error messages on machines which does not have valid License.

SO please check if you can find how many computers are throwing error messages while patching. Run this query on the DB to find out which machines are using valid license and which are not.

This query is specific to Patch management Solution

select vc.name
From licenseinuse liu
join vcomputer vc on vc.guid = liu.ResourceGuid
where liu.LicensingPolicyGuid = 'B1338338-5575-4A27-9808-23BEC40D79FA'
order by vc.name
 

Hope this Helps

Cheers:-)

Hi, to be honest its on all the machines I checked. These are older machines and would have been installed when we had plenty of licences. How would I run this query ion an SQL express box (not got any DB expereince)

Thanks

Joe.

You would need to install the SQL Management studio but if it is on every computer it would be best to get the agent.log files from an agent.

It could be that the computers are not part of a needed policy.  It may also be helpful to run the NS.CompleteResourcemembershipUpdate schedule from the Windows Scheduled tasks on the server.

Hi,

I Tried to run your query and get

Msg 208, Level 16, State 1, Line 1
Invalid object name 'LicenseInUse'.

J.