1. BrightGauge Support
  2. Community
  3. Community - Community Queries for SQL based Datasets

Percentage patched for servers only

Avatar
Ioannis Kokkinis

Displays a single percentage number of patches for all the servers for a company

Select
clients.Company,
(Sum(v_hotfixes.Installed) / Count(v_hotfixes.kbID)) As percentagepatched,
clients.ClientID
From
clients Inner Join
v_computers On clients.ClientID = v_computers.ClientID Inner Join
v_hotfixes On v_computers.ComputerID = v_hotfixes.ComputerID
Where
v_computers.OS Like '%Server%'
Group By
clients.Company, clients.ClientID

Didn't find what you were looking for?

New post
Would you like to vote for this feature?
0 out of 0 found this helpful

Comments

0 comments