I've recently been given access to the LANDesk management suite web front end in order to create queries and reports that can monitor patching KPIs across our estate. I don't have access to any SQL reporting or querying tools. I've been told that although we have Data Analytics it is not accessible from the web front end.
I need to create a query that I can then put into a Excel in order to determine the distribution of outstanding patches by age and criticality, i.e. a PivotChart with count on the Y axis and age in weeks on the X axis, this being calculated at TODAY - patch_publication_date
I can then cut this in different ways to analyse by criticality, installed(Y.N) software vendor, etc.
I think the basic column headings I need are;
|Device Name||Vulnerability Id||Patch Date Published||Patch Severity||Age Wks||Severity||Vendor||Date patch installed||Successfully Installed|
I've been looking at the tables(views?) "Patch and Compliance Definitions" and "Detected Patch and Compliance Definitions" but don't seem to be able to get exactly what I want, for starters the query seems to do an outer join when adding tables, I've also got a report generated by my IT department using Data Analytics that contains at least one vulnerability ID that does not exist in either of these tables. So I'm a little confused
Anyhow, is there any kind soul out there who could point me in the right direction for producing what I'm looking for, or maybe give me a Data Analytics query that I can supply to IT to run for me?
Also, does anyone know if is it possible for me to have access to Data Analytics without requiring access to the LANDesk server, either through a thick client or a web front end?
Thanks in advance,
Installed LANDesk software
LANDESK Software 9.60 - Service Pack 1 : 22.214.171.124B
LANDesk Software 9.60.1 - Software License Monitoring : 9.60.1
LANDESK Software - Data Analytics : 9.61.0521
LANDESK Software - Data Analytics Content : 10.2.1259
LANDESK Software 9.60.1 - BASE : 2015-0114D
LANDESK Software 9.60.1 - EPS : 2015-0114D
LANDESK Software 9.60.1 - RC : 2015-0114D