How do I report on percentage of machines in PDQ Inventory?
I've been asked by management to produce some weekly reports on computers meeting or not meeting certain criteria. I've already got working collections and auto reports, but they want the results expressed as a percentage of computers rather than a total number or a list.
An example might be:
- Percentage of workstations running Windows 10 Pro release 1810 or later (supported)
- Percentage of workstations running Windows 10 Pro release earlier than 1810 (unsupported)
In this example, I would have a collection defined for the total of all workstations, a collection for the subtotal of Win10 workstations with a supported version and a collection for those on unsupported versions (actually I'd use a variable for the release number).
I can auto report as plain text files to my email or to a folder with the count for each, then work out the percentage by hand using (100/total)*subtotal and email it out to management.
What I'd like is to have an email sent from the server each week with the percentage figures in the body, but an attachment for each percentage would be fine.
I'm sure it's possible, but it'll require better SQL or Powershell skills than I have. Anyone fancy taking a shot at it?