Custom Report - Filter on OS

Hello Gregor,

most of the information I'm after
what information are you after? And automated means that you want to run them on a schedule? You'll likely have to use the Reporting Interface, there's a recent thread about Finding out-of-date status. vComputerHostData provides the OperatingSystemID and OperatingSystemName.

Christian

Thanks for the quick reply.

All I need at this stage is the computer name, OS and the 'Up to date' value. I can then expand on this as necessary.

I'm happy to use SSRS but Sophos doesn't provide any details on configuring this, only for Crystal Reports.

Hello Gregor,

any details on configuring [SSRS]
the necessary details are the same as for Crystal Reports: database connection/data source. I'm perhaps nit-picky but you don't configure these tools when you create a report. SSRS is a set of tools and services. Microsoft have a lot of documentation and tutorials on their website, e.g how to create a Basic Table Report. If all you need is a table running the query in a .sql script with sqlcmd is all you'd need.

What's the purpose of the automated report, just asking as you want to limit this just to a particular OS (Windows Server *)? IMO you shouldn't have continuously out-of-date servers which would justify an automated report.

Christian

I know no one should have out of date computers, but it does happen, whether it's actually the case or Sophos is reporting wrong. And to save us looking this up manually, an automated report would be great.

Your previous link should do what I need it to but is there a way to get the actual status value of "Not since DD/MM/YYYY hh:mm:ss"?

Thanks again.

Hello Gregor,

a way to get the actual [out-of-date]?
as outlined it's a computed value and depends on the timezone of the console - not the management server (or the endpoint). If you're running a remote console and change the timezone you'll see that these values change accordingly.

looking this up manually
is not too hard when using the console. While using the Protection/Out-of-date computers link from the Dashboard shows only the Managed connected out-of-date computers the View: drop down also offers Managed out-of-date computers:

Combine this with a sub-estate containing only the endpoints with the OS of interest (provided they are in their own groups) you can easily get these data with the console. But even if your groups contain both desktops/laptops and servers you could sort them by OS version to pool the endpoints.

Christian

Thanks Christian. It's just more 'slick' if SCOM or another management platform can do the monitoring and alerting.

I'm almost there but the list reported is a lot bigger than the 'Managed out-of-date computers'. I'm guessing my query is based on all the machines in the estate, with 'server' in the OperatingSystemName. Is it possible to further modify this to just 'Managed' computers?

Hello Gregor,

looks like vCHD contains delezted computers as well. Off the top of my head, you'd have to join AliveComputers as AL on vCHD.ComputerID=AL.ID Where AL.Deleted=0

Christian

Awesome, that did it, just needed AL.Connected = 1.

Thanks for all your help!

Awesome, that did it, just needed AL.Connected = 1.

Thanks for all your help!