Skip to main content
Skip table of contents

Security & IT Ops Dashboards

The pre-built Value-Oriented Dashboards include the following Security & IT Ops dashboards:

  • Certificate Summary. This dashboard displays information about SSL certificates, including information about the key algorithms, expiry dates, CA, and certificate versions.

  • EOL Operating Systems. This dashboard provides information about operating systems and operating system versions, including EOL operating systems.

Required Connectors

To find all the assets in your environment, including certificate information about those assets and operating system information about those assets, Lucidum recommends you configure Lucidum connectors for:

  • The Endpoint Management solutions in your environment (for example, Jamf, Intune, Citrix Endpoint Management, Symantec Endpoint Management, Hexnode)

  • The Endpoint Protection solutions in your environment (for example, Trellix Endpoint Security, Symantec Endpoint Protection, SentinelOne, Crowdstrike Falcon, Microsoft Defender for Endpoint )

  • The Mobile Device Management solutions in your environment (for example, Addigy, Citrix Endpoint, Jamf Pro, Kandji)

  • The directory solutions in your environment (For example, Azure AD, Microsoft AD, Jump Cloud, PingOne, OpenLDAP,)

  • The DHCP solutions in your environment (For example, Infoblox, Efficient IP, BlueCat)

  • The VPN solutions in your environment (For example, Cisco AnyConnect, FortiClient, Palo Alto VPN, Citrix Gateway, Zscaler Private Access)

  • The cloud solutions in your environment (for example, AWS, Azure, Google Cloud, Oracle Cloud)

Certificate Summary

The Certificate Summary dashboard displays information about SSL certificates, including information about the key algorithms, expiry dates, CA, and certificate versions.

The Certificate Summary dashboard looks like this:

Base Query

Most of the charts in this dashboard use a query like:

Asset Type match CERT

This query searches for all certificates in the environment.

Charts

To view details about each chart, click the pencil icon (

).

  • Certificates Total. This chart displays the total number of certificates in the environment.

    • This chart uses the query Asset Type match CERT. This query searches for all certificates.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart does not use an additional filter.

    • The Chart Type is “Big Number”.

  • Algorithms. This chart displays the type of key algorithms in use by all the certificates.

    • This chart uses the query Asset Type match CERT. This query searches for all certificates.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Certificate Algorithm. This filter displays the certificate algorithms in use and the number of certificates assigned to each algorithm.

    • The Chart Type is “Pie”.

  • Certificates: All Expiry Dates. This chart displays the next five expiry dates for certificates.

    • This chart uses the query Asset Type match CERT. This query searches for all certificates.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Asset Expiry Time::Day. This filter displays the upcoming expiry days and and the number of certificates assigned to each expiry day.

    • The Chart Type is “Bar”.

  • Certificates by CA. This chart displays the certificate authorities in use and the number of certificates assigned to each CA.

    • This chart uses the query Asset Type match CERT. This query searches for all certificates.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Vendor. This filter displays the vendors for certificates (the CA) and the number of certificates assigned to each CA.

    • The Chart Type is “Bar”.

  • Certificate Versions. This chart display the types of certificates in the environment.

    • This chart uses the query Asset Type match CERT. This query searches for all certificates.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Certificate Version. This filter displays the versions for certificates (for example, SSLv2, SSLv3, TLS1.3) and the number of certificates assigned to each version.

    • The Chart Type is “Pie”.

  • Expired Certs. This chart displays the number of certificates that have already expired.

    • This chart uses the query Asset Type match CERT AND Expiry time within past 999 years. This query searches for all expired certificates in the environment.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Asset Expiry Time::Day. This filter displays the expired certificates by the day they expired.

    • The Chart Type is “Bar”.

  • Expired Certs All Expired. This chart displays the domains that have expired certificates.

    • Asset Type match CERT AND Expiry time within past 999 years. This query searches for all expired certificates in the environment.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter Count Asset Expiry Time by Domain. This filter displays the domains associated with each expired certificate.

    • The Chart Type is “Table”.

  • Full Certificate List. This chart displays all domains with certificates.

    • This chart uses the query Asset Type match CERT. This query searches for all certificates.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Full Domain Name. This filter displays the domain names for all certificates.

    • The Chart Type is “Table”.

  • Upcoming Expirations. This table lists the expiry dates coming up in the next 60 days and the number of assets that will expire on those dates.

    • This chart uses the query Asset Type match CERT AND Asset Expiry Time within future 60 days. This query searches for all certificates that will expire in the next 60 days

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by Asset Expiry Time::Day. This filter displays all the expiry days in the next 60 days and the number of certificates that will expire on each of those expiry days.

    • The Chart Type is “Bar”.

  • Upcoming Expirations 60 Days Out. This chart displays the domains for which certificates will expire in the next 60 days.

    • This chart uses the query Asset Type match CERT AND Asset Expiry Time within future 60 days. This query searches for all certificates that will expire in the next 60 days.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter Count Asset Expiry Time by Full Domain Name. This filter displays the domains associated with each certificate that will expire in the next 60 days.

EOL Operating Systems

The EOL Operating Systems dashboard provides information about operating systems and operating system versions, including EOL operating systems.

The EOL Operating Systems dashboard looks like this:

Base Query

Most of the charts in this dashboard use a query like:

OS and Version match windows AND Asset Type not match VM_Image

This query searches for Windows OS version on assets that are not VM images.

If you want to edit this dashboard to monitor other operating systems, you can select a different value for OS and Version.

Charts

To view details about each chart, click the pencil icon (

).

  • All Windows Assets by OS Version. This chart displays the total number of Windows assets for each Windows OS version.

    • This chart uses the query OS and Version match windows AND Asset Type not match VM_Image. This query searches for all assets Windows operating systems but not VM Images assets.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by OS and Version. This filter displays all the Windows versions in the environment and shows the number of assets for each Windows version.

    • The Chart Type is “Bar”.

  • EOL Windows Assets by OS Ver. This chart displays all the end-of-life Windows versions in the environment and the number of assets running each EOL version of Windows.

    • This chart uses the query OS and Version match windows AND OS and Version match 1607 OR OS and Version match 1703 OR OS and Version match 1709 OR OS and Version match 1803 OR OS and Version match 1809 OR OS and Version match 1903 OR OS and Version match 1909 OR OS and Version match 2004 OR OS and Version match 20H2 OR OS and Version match 2008 OR OS and Version match windows7. This query searches for all assets running Windows operating systems that are EOL versions.

    • This chart uses the additional filter count Lucidum Asset Name by OS and Version. This filter displays all the EOL Windows versions in the environment and shows the number of assets for each EOL Windows version.

    • The Chart Type is “Bar”.

  • All MacOS Assets by OS Version. This chart displays the total number of Mac assets for each MacOS version.

    • This chart uses the query OS and Version match apple OR OS and Version match macos OR OS and Version match Catalina OR OS and Version match Monterey OR OS and Version match big sur OR OS and Version match mac os OR Vendor match Apple AND OS and Version not match windows or OS and Version not match ubuntu. This query searches for all Mac assets running MacOS.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by OS and Version. This filter displays all the MacOS versions in the environment and shows the number of assets for each MacOS version.

    • The Chart Type is “Bar”.

  • EOL MacOS Assets by OS Version. This chart displays all the end-of-life MacOS versions in the environment and the number of assets running each EOL version of MacOS.

    • This chart uses the query OS and Version not match windows OR OS and Version not match linux OR OS and Version not match ubuntu OR OS and Version not match centos OR OS and Version not match android OR OS and Version not match unknown AND OS and Version exists AND OS and Version match 10.1[1234]. This query searches for all assets that are not running any operating system other than MacOS, that are running an operating system, and that are running an operating system with the version 10.11, 10.12, 10.13 or 10.14.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter count Lucidum Asset Name by OS and Version. This filter displays all the EOL MacOS versions in the environment and shows the number of assets for each EOL MacOS version.

    • The Chart Type is “Bar”.

  • EOL Windows Assets (Not Including AWS Generic "WINDOWS" EC2). This chart displays the name of each asset running an EOL version of Windows and the number of vulnerabilities associated with each asset.

    • This chart uses the query OS and Version match windows AND OS and Version match 1607 OR OS and Version match 1703 OR OS and Version match 1709 OR OS and Version match 1803 OR OS and Version match 1809 OR OS and Version match 1903 OR OS and Version match 1909 OR OS and Version match 2004 OR OS and Version match 20H2 OR OS and Version match 2008 OR OS and Version match windows7. This query searches for all assets running Windows operating systems that are EOL versions.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter sum High Vulns by Lucidum Asset Name. This filter displays the name of each asset running an EOL version of Windows and the number of vulnerabilities associated with each asset.

    • The Chart Type is “Table”.

  • EOL Windows Assets by Department (Not Including AWS Generic "WINDOWS" EC2). This chart displays the name of each department that has EOL windows assets and the number of such assets in each department.

    • This chart uses the query OS and Version match windows AND OS and Version match 1607 OR OS and Version match 1703 OR OS and Version match 1709 OR OS and Version match 1803 OR OS and Version match 1809 OR OS and Version match 1903 OR OS and Version match 1909 OR OS and Version match 2004 OR OS and Version match 20H2 OR OS and Version match 2008 OR OS and Version match windows7. This query searches for all assets running Windows operating systems that are EOL versions.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter Lucidum Asset Name by Department. This filter displays the name of each department that has EOL windows assets and the number of such assets in each department.

    • The Chart Type is “Bar”.

  • EOL MacOs Assets. This chart displays the name of each asset running an EOL version of MacOS and the number of vulnerabilities associated with each asset.

    • This chart uses the query OS and Version not match windows OR OS and Version not match linux OR OS and Version not match ubuntu OR OS and Version not match centos OR OS and Version not match android OR OS and Version not match unknown AND OS and Version exists AND OS and Version match 10.1[1234]. This query searches for all assets that are not running any operating system other than MacOS, that are running an operating system, and that are running an operating system with the version 10.11, 10.12, 10.13 or 10.14.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter sum High Vulns by Lucidum Asset Name. This filter displays the name of each asset running an EOL version of MacOS and the number of vulnerabilities associated with each asset.

    • The Chart Type is “Table”.

  • EOL MacOS Assets by Department. This chart displays the name of each department that has EOL MacOS assets and the number of such assets in each department.

    • This chart uses the query OS and Version not match windows OR OS and Version not match linux OR OS and Version not match ubuntu OR OS and Version not match centos OR OS and Version not match android OR OS and Version not match unknown AND OS and Version exists AND OS and Version match 10.1[1234]. This query searches for all assets that are not running any operating system other than MacOS, that are running an operating system, and that are running an operating system with the version 10.11, 10.12, 10.13 or 10.14.

    • The Summary further filters and organizes the query results (set of additional fields for each Lucidum Asset Name that matches the query) for display in the chart. This chart uses the additional filter Lucidum Asset Name by Department. This filter displays the name of each department that has EOL MaOS assets and the number of such assets in each department.

    • The Chart Type is “Bar”.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close