Sometimes we need you to provide log files, including information about your Advanced Insights instance. Your Advanced Insights deployment includes the Log Collector executable that can be used to collect all required logs.

**Note**

The Advanced Insights Log Collector is located at:

_`%Advanced Insights Install Directory%`_`ApiLogCollectorAdvancedInsightsLogDiag.exe`

For example:

`C:Program Files (x86)Advanced InsightsApiLogCollectorAdvancedInsightsLogDiag.exe`

The Log Collector can be executed manually and is also used within the Advanced Insights installer. Once the log collection process is completed, a zip file is created on the desktop called:

**AdvancedInsights_Diag_xxxxxxxx_xxxxxx.zip**

This ZIP should be shared with Patch My PC technical support.

_Example output:_


This page provides details about what information the AdvancedInsightsLogDiag.exe collects.

Advanced Insights data and installation logs

The contents of the following directory are collected, which consist of the ‘AdvancedInsightsApi.log’ and any ‘AdvInsights_Verx.x.x.zip’ installer logs.

C:ProgramDataAdvancedInsightsLogs


Windows Application Event Log

The Windows Application Event log data is collected and output into ‘Application_EventLog.log’ with a filter applied for the following event sources:

  • “.NET Runtime”
  • “Advanced Insights”
  • “MsiInstaller” – if required to diagnose install problems, the filter will include

Advanced Insights SQLite db

The ‘ConfigManagerLocation’ and ‘ConfigManagerDatabase’ value are collected from the Advanced Insights SQLite database file located at:

‘C:ProgramDataAdvancedInsightsDataApiAdvancedInsightsConfig.db’

SQL Server information

The following information is queried from the SQL Server instance where the Configuration Manager database is located:

SQL Master db:

  • Configuration Manager database name
  • Configuration Manager databaste state (ONLINE/OFFLINE)
  • Configuration Manager database compatibility level
  • Configuration Manager database .mdf file path
  • Configuration Manager database file size
  • Configuration Manager database log file .ldf path
  • Configuration Manager database log file size
  • SQL Server version
  • SQL Server Product Level
  • SQL Server Edition
  • SQL Server Engine Edition
  • SQL Server Product build
  • SQL Server Product Major version
  • SQL Server Product minor version
  • SQL Server Product update version
  • SQL Server Installed updates
  • SQL Server remote query timeout value
  • SQL Server maximum degree of parallelism value
  • SQL Server Minimum size of server memory (MB)
  • SQL Server Maximum size of server memory (MB)

Configuration Manager SQL database:

  • Advanced Insights Inventory Extensions class names and data counts.
  • Advanced Insights Inventory Extensions Configuration Manager application information. For example ‘Name’, ‘created date’, ‘version’, ‘number of deployments’.
  • Configuration Manager database level SQL configured properties:
    • MAXDOP
    • LEGACY_CARDINALITY_ESTIMATION
    • PARAMETER_SNIFFING
    • QUERY_OPTIMIZER_HOTFIXES

Windows Server IIS information

  • Information related to the Advanced Insights IIS websites and application pools are collected.
  • Advanced Insights Api
  • Advanced Insights Frontend
  • Website name
  • HTTPS bindings included the current SSL certificate properties

Windows Server information

  • The version of Advanced Insight currently installed.
  • The install date of Advanced Insights.
  • The install path of Advanced Insights.
  • The install source of Advanced Insights.
  • Server CPU properties.
  • Installed Server RAM
  • Server disks including total size and free space
  • Windows OS version
  • Check for Server pending restart.
  • List Windows updates installed in the last 30 days.