You may need to investigate or send your log files in order to troubleshoot an issue with Snow License Manager (SLM). This article outlines many of the key locations for log files.
Jump to log files for:
-
Data Update Job issues, data in Snow Inventory that is not in Snow License Manager
-
Error message in the SLM web interface
-
Security, login authentication for SLM web interface
Environment
- Snow License Manager (SLM) 8.x, 9.x
Details
Location is for logs on the SLM/Application server unless stated otherwise.
Action Log
Contains information about changes made in SLM.
Location - SLM web GUI - Administration - Action Log
Snow License Manager Web Application General (SLM 8.x, 9.x)
Contains information about license key validation, database connection status, application initialization status.
Location - %:\Program Files\Snow Software\Snow License Manager\Web\Logs\Application
Snow License Manager Web Application Error (SLM 8.x, 9.x)
Contains information about error messages generated within the web GUI.
Location - %:\Program Files\Snow Software\Snow License Manager\Web\Logs\Error
Snow License Manager Web Application Security (SLM 8.x, 9.x)
Contains information about failed user login attempts.
Location - %:\Program Files\Snow Software\Snow License Manager\Web\Logs\Security
Snow License Manager Web API (SLM 8.x, 9.x)
Contains information about access to the Web API.
Location - %:\Program Files\Snow Software\Snow License Manager\Web\Logs\WebAPI
Snow License Manager 8 Services (SLM 8.x, 9.x)
All service binaries and configurations.
Location - %:\Program Files\Snow Software\Snow License Manager\Services
All service logs.
Location - %:\Program Files\Snow Software\Logs
Snow License Manager Event Store Service (SLM 8.x, 9.x)
Manages the event store database which is used for storing Office 365 data from the Microsoft portal.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\EventStore
Logs
Location - %:\Program Files\Snow Software\Logs\EventStoreService
Snow License Manager File Import Service (SLM 8.x, 9.x)
Runs the automatic and manual file imports.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\ImportTool
Logs (set in Web Configurator Import Service)
Location - %:\Program Files\Snow Software\Logs\ImportTool\ImportTool_
Snow License Manager Inventory Service (SLM 9.x)
Runs the deletion sync of computers users and devices between SLM DB and INV DB.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\InventoryService
Logs (set in Web Configurator Import Service)
Location - %:\Program Files\Snow Software\Logs\InventoryService
Snow License Manager Notification Delivery Service (SLM 8.x, 9.x)
Manages the scheduling of notifications.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\NotificationDelivery
Logs
Location - %:\Program Files\Snow Software\Logs\NotificationDelivery
Snow License Manager Office 365 Service (SLM 8.x, 9.x)
Manages the Office 365 data.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\Office365
Logs
Location - %:\Program Files\Snow Software\Logs\Office365
Snow License Manager Report Exporter (SLM 8.x, 9.x)
Manages the scheduling of reports.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\ReportExport
Logs
Location - %:\Program Files\Snow Software\Logs\ReportExport
Snow Software Licensing Service (SLM 8.x, 9.x)
Handles the compliance calculation. If this is stopped no license compliance information will be updated manually or automatically.
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\LicensingService
Logs
Location - %:\Program Files\Snow Software\Logs\LicensingService
Snow Software Licensing (SLM 8.x, 9.x)
Checks and validates the Snow License keys
Binaries and configurations
Location - %:\Program Files\Snow Software\Snow License Manager\Services\Licensing
Logs
Location - %:\Program Files\Snow Software\Logs\Licensing
Data Update Job (DUJ) (SLM 8.x, 9.x)
The DUJ transfers data from Snow Inventory to Snow License Manager.
It writes all its logs to the SnowLicenseManager SQL database.
Copy with headers to Excel
To find these logs run the below queries against the SQL database that runs the SnowLicenseManager database:
The log of the last DUJ:
SELECT * FROM SnowLicenseManager.dbo.tblJobLog
Logs from previous DUJs:
SELECT * FROM SnowLicenseManager.dbo.tblJobLogHistory
The error log from all DUJ runs:
SELECT * FROM SnowLicenseManager.dbo.tblErrorLog
Meta data for all DUJ runs:
SELECT * FROM SnowLicenseManager.dbo.tblJobLogMetrics
Other helpful logs:
SELECT * FROM msdb.dbo.sysjobhistory where sql_severity > 0 order by run_date desc, run_time desc;
SELECT * FROM SnowLicenseManager.dbo.tblCIDDataSource;
SELECT * FROM SnowLicenseManager.dbo.tblInventoryDatabaseLog;
SELECT * FROM SnowInventory.inv.DbVersionHistory;
SELECT * FROM SnowLicenseManager.inv.tblJobParallelStep;
