Reports You Can Run with the ReportRunner Application

You can run most, but not all, reports using ReportRunner, which enables you to set up reports to run on a scheduled basis.

 This topic applies to CAM authentication.

The reports you can run with this application are listed below along with a short description, the name of the report as it must appear when running ReportRunner (--report=reportname), and additional parameters you can include.

For more information, see How to Schedule and Email Reports Using ReportRunner.

Administrative Tools Reports

  • CAM Administration Discovery Servers: Information on what CAM Administration Service machines have performed discovery tasks.

    • --report=AdministrationServersDiscovery

  • CAM History: Record of Cherwell Asset Management operations.

    • History detail: --report=CAMHistoryDetail
    • By user: --report=CAMHistoryUser
    Report parameters:
    • All events: --add=CAMHistoryInputAction=All
    • Machine-related events: --add=CAMHistoryInputAction=Machines
    • User-related events: --add=CAMHistoryInputAction=Users
    • License units: --add=CAMHistoryInputAction=License Units
    • Assets: --add=CAMHistoryInputAction=Assets
    • Profiles: --add=CAMHistoryInputAction=Profiles
    • Contracts: --add=CAMHistoryInputAction=Contracts
    • Other: --add=CAMHistoryInputAction=Other

  • CAM License Utilization: List of machines consuming a CAM license.

    • --report=MachinesUsingCamLicenseDetail

    Report parameters:

    • All platforms: --add=Platform=-1
    • Windows platform: --add=Platform=400
    • Mac OS platform: --add=Platform=100
    • Linux/Unix platform: --add=Platform=500

  • CAM Windows Agent Status: CAM Windows Agent installation and inventory status.

    • --report=CAMAgentStatus

    Report parameters:

    • All machines: --add=ExpressClientStatusInputType=All
    • Machines using a CAM Agent license: --add=ExpressClientStatusInputType=CAM

  • Database Script Log: Information about when database scripts were run.

    • --report=DatabaseScriptLog

  • Failed CAM Windows Agent Installs/Inventories: A list of CAM Windows agent machines where installation or inventory has failed.

    • --report=FailedInstallOrInventory

  • Group Membership: A list of license units, machines, users, or assets contained in each group.

    • --report=GroupMembershipDetail

    Report parameters:

    • Assets: --add=type=3
    • License units: --add=type=2
    • Machines: --add=type=0
    • Users: --add=type=1

  • Last User Login: Information about the last time a user logged into and out of a machine.

    • Ungrouped: --report=LastUserLoginDetail
    • Grouped by user group: --report=LastUserLoginByGroupDetail
    • Grouped by machine: --report=LastUserLoginByMachine
    • Grouped by Terminal Server: --report=LastUserLoginByTerminalServer

  • Unreconciled Machine Export: A list of machines that have not been reconciled to purchasing data. Use this report as a starting point to create a spreadsheet for importing computer purchase data.

    • --report=UnreconciledMachineExportExcel

File Management Reports

  • Non-runnable Files: Any non-runnable files that were collected during machine inventory.

    • Grouped by extension: --report=NonRunnableFilesByExtension
    • Grouped by machine: --report=NonRunnableFilesByMachine
    • Summary: --report=NonRunnableFilesSummary

  • Unconfigured Files by Count: List of all files that have not been configured sorted by count, sorted by the number of installations (the count).

    • --report=UnconfiguredFilesByCount

Hardware Inventory

  • Machine Drives Summary: Disk drive summary information for each machine.

    • --report=MachineDrivesSummaryExport

  • Machine List: A simple list of machines that conform to the filter requirements.

    • --report=MachineList

Purchasing and License Management Reports

  • Am I Compliant: Information to help determine whether your organization is in compliance with its software licensing agreements.

    • --report=AmICompliant

  • Concurrent Software License Allocation: Information about how concurrent licenses are allocated by group.

    • Grouped by allocation group: --report=LicenseAllocationByAllocationGroup
    • Grouped by license unit: --report=LicenseAllocationByLicenseUnit

  • License Unit Maintenance Expiration: Information on whether any maintenance agreements for your license unit purchases have expired.

    • --report=MaintenanceExpiration
    • Optional parameter: --add=MaintenanceExpirationInputType=<days>
      For <days>, enter the number of days before expiration.

  • License Unit Purchase History: Summary of all configured license unit purchases.

    • Ungrouped: --report=LicenseUnitPurchaseHistoryUngrouped
    • Grouped by category: --report=LicenseUnitPurchaseHistoryByCategory
    • Grouped by license unit group: --report=LicenseUnitPurchaseHistoryByGroup
    • Grouped by manufacturer: --report=LicenseUnitPurchaseHistoryByManufacturer

  • License Unit Summary and Machine Assignments: License unit summary that displays machine assignment details.

    • By machine group: --report=LUSummaryAndMachineAssignmentsByMachineGroup
    • Ungrouped: --report=LUSummaryAndMachineAssignmentsUngrouped

  • Product ID: All product IDs associated with applications found on machines in the network.

    • Grouped by application: --report=ProductIDByApplication
    • Grouped by license channel: --report=ProductIDByLicenseChannel
    • Grouped by machine: --report=ProductIDByMachine
    • In Excel format: --report=ProductIDByMachineExcel

  • Purchase Summary: Purchase summary by group assignment and line item type.

    • By group: --report=PurchaseSummaryByGroup
    • By line item: --report=PurchaseSummaryByLineItemType

  • Software Inventory and Order Summary: License summary and order information for license units.

    • Ungrouped: --report=SoftwareInventorySummaryUngrouped
    • Operating systems only: --report=SoftwareInventorySummaryOS
    • Grouped by category: --report=SoftwareInventorySummaryByCategory
    • Grouped by license unit group: --report=SoftwareInventorySummaryByGroup
    • Grouped by manufacturer: --report=SoftwareInventorySummaryByManufacturer
    Additional parameter:
    • --add=orderDetail=1
      If you do not pass in this parameter, the Software Inventory Summary report (described next) is returned.

  • Software Inventory Summary: Summary information about all license units.

    • Ungrouped: --report=SoftwareInventorySummaryUngrouped
    • Operating systems only: --report=SoftwareInventorySummaryOS
    • Grouped by category: --report=SoftwareInventorySummaryByCategory
    • Grouped by license unit group: --report=SoftwareInventorySummaryByGroup
    • Grouped by manufacturer: --report=SoftwareInventorySummaryByManufacturer
    Report parameters:
    • Includes all filtered-in license units: --add=agfilter=0 (default)

      or

      Takes filtering/groups into account when computing license totals:--add=agfilter=1

    • Includes all filtered-in license units: --add=nzonly=0 (default)

      or

      Returns only those with non-zero installation, launch, or license counts: --add=nzonly=1

  • Software Recently Discovered: New license units recently discovered on your network.

    • --report=SoftwareRecentlyDiscovered

    Additional parameter:

    • --add=SoftwareRecentlyDiscoveredInputType=<days>
      The value you specify for <days> indicates that you want to find license units discovered within that number of days.

  • Unused Software: List of all software that is installed by has not been used.

    • By license unit: --report=UnusedSoftwareByLicenseUnit
    • By machine: --report=UnusedSoftwareByMachine
    • By manufacturer: --report=UnusedSoftwareByManufacturer
    • Ungrouped: --report=UnusedSoftwareUngrouped

Oracle Reports

  • Oracle Database Summary: Oracle database summary by physical host.

    • --report=OracleDatabaseSummary

  • Oracle Feature Summary: Oracle option and management pack summary.

    • --report=OracleOptionAndManagementPackSummary

Software Inventory Reports

  • ISO Software ID Tags: Information about ISO 19770-2 software identification tags in your environment.

    • By machine: --report= ISOSoftwareIDTagsByMachine
    • By software creator: --report=ISOSoftwareIDTagsBySoftwareCreator
    • Ungrouped: --report=ISOSoftwareIDTagsUngrouped

  • Software Application Summary: Installation count for each application version.

    • --report=SoftwareApplicationSummary

  • Software Installation by Machine Group, Version: List of installed software locations by machine group.

    • --report=SoftwareInstallationByGroupVersion

  • Software Installation by Version: For each suite/application, the version, machine name, and installation path of each occurrence.

    • --report=SoftwareInstallationByVersion

  • Software Inventory: Installed applications/suites and their locations.

    • Grouped by license unit: --report=SoftwareInventoryByLicenseUnit
    • Grouped by machine: --report=SoftwareInventoryByMachine
    • Grouped by machine group: --report=SoftwareInventoryByMachineGroup
    • Grouped by user: --report=SoftwareInventoryByUser
    • Grouped by user group: --report=SoftwareInventoryByUserGroup
    • Grouped by category: --report=SoftwareInventoryCategoryDrilldown
    • Grouped by manufacturer: --report=SoftwareInventoryManufacturerDrilldown

  • Suite Application: Information about suites on your network, grouped by application or suite name, or by machine.

    • Installations grouped by application: --report=SuiteApplicationByApplication
    • Installations grouped by suite: --report=SuiteApplicationBySuite
    • Launches grouped by machine: --report=SuiteApplicationLaunchesByMachine

Software Usage Reports

  • Activity Log: License unit activity, grouped by license unit, machine, server, or user, and sorted by time.

    Use one of these report names:

    • Grouped by machine: --report=ActivityLogByMachine
    • Grouped by license unit: --report=ActivityLogByLicenseUnit
    • Grouped by server: --report=ActivityLogByServer
    • Grouped by machine and license unit: --report=ActivityLogByMachineLicenseUnit
    • Grouped by machine with Terminal Servers: --report=ActivityLogByMachineWithTerminalServer
    • Grouped by user: --report=ActivityLogByUser
    • Grouped by user with Terminal Servers: --report=ActivityLogByUserWithTerminalServer
    • Grouped by user and license unit:--report= ActivityLogByUserLicenseUnit

  • Concurrent Software Peak Usage: The peak number of users running each license unit that is configured for concurrent use.

    • --report=PeakUsage

  • Concurrent Software Statistics: Statistical information about launches for concurrent license units, including launch counts and usage information.

    • Ungrouped: --report=ConcurrentLicenseStatisticsUngrouped
    • Grouped by machine: --report=ConcurrentLicenseStatisticsByMachine
    • Grouped by user: --report=ConcurrentLicenseStatisticsByUser
    • Grouped by license unit group: --report=ConcurrentLicenseStatisticsByGroup

  • Software Usage Statistics: Analysis of software usage trends.

    • Grouped by license unit: --report=SoftwareUsageStatisticsByLicenseUnit
    • Grouped by machine: --report=SoftwareUsageStatisticsByMachine
    • Grouped by machine and user: --report=SoftwareUsageStatisticsByMachineUser
    • Grouped by machine with Terminal Servers: --report=SoftwareUsageStatisticsByTerminalServer
    • Grouped by user: --report=SoftwareUsageStatisticsByUser

  • Software Usage Summary: Summary information about license units that are licensed concurrently.

    • Ungrouped: --report=SoftwareUsageSummaryUngrouped
    • Grouped by category: --report=SoftwareUsageSummaryByCategory
    • Grouped by license unit group: --report=SoftwareUsageSummaryByGroup
    • Grouped by manufacturer: --report=SoftwareUsageSummaryByManufacturer

  • Unique Application Paths by Version (Metered): A list of all unique paths from which an application is launched.

    • --report=UniqueApplicationPaths

  • Unique Application Users by Version (Metered): A list of all unique users of an application.

    • --report=UniqueApplicationUsers

Reports That Cannot Be Scheduled

You cannot run these reports via Report Runner; you must use Reporting to run them:

  • Activity Log (ungrouped)
  • Custom Expense History
  • Custom Inventory
  • Custom Network Devices
  • Dashboard
  • Expense History
  • License Unit Custom Purchase History
  • Machine Properties
  • Machine Search
  • Microsoft MSDN
  • Network Devices
  • Other Assets
  • Software End of Life
  • Unconfigured Files
  • Virtual Machines and Hosts
  • What's Changed
  • What's Changed: Added or Deleted Machines