Great, thanks for clarifying! ... View more

The first part of the inventory .ndi filename identifies the user account that the ndtrack inventory gathering process ran as. On Windows, this process is typically run as the "SYSTEM" user, which matches what you see in the filename. On OS X, as long as the username identified in the NDI filename has root rights then I expect all should be OK. If you are somehow running the ndtrack process as a user that does not root rights, then you may find that there are some details that don't get included in the inventory compared to what would be included if you ran the process with root rights. ... View more

The following query has been extended to include details of applications files are linked to via file evidence recognition rules: SELECT ic.ComputerName, ife.FileName, iifep.ExternalFilePath, ic.InventoryDate, er.RuleDefaultString, st.FullName FROM dbo.ImportedInstalledFileEvidence iife JOIN dbo.ImportedComputer ic ON ic.ComplianceConnectionID = iife.ComplianceConnectionID AND ic.ExternalID = iife.ExternalID JOIN dbo.ImportedFileEvidence ife ON ife.ComplianceConnectionID = iife.ComplianceConnectionID AND ife.ExternalFileID = iife.ExternalFileID JOIN dbo.ImportedInstalledFileEvidencePath iifep ON iifep.ComplianceConnectionID = iife.ComplianceConnectionID AND iifep.ExternalFilePathID = iife.ExternalFilePathID LEFT OUTER JOIN ( dbo.ImportedFileEvidenceMapping ifem JOIN dbo.SoftwareTitleFileEvidence stfe ON stfe.FileEvidenceID = ifem.FileEvidenceID JOIN dbo.EvidenceExistenceRuleI18N er ON er.EvidenceExistenceRuleID = stfe.EvidenceExistenceRuleID AND er.RuleDefaultString IN ('Required', 'At least one') LEFT OUTER JOIN dbo.SoftwareTitle st ON st.SoftwareTitleID = stfe.SoftwareTitleID ) ON ifem.ComplianceConnectionID = iife.ComplianceConnectionID AND ifem.ExternalFileID = iife.ExternalFileID ... View more

Hi Kyle, I agree with @ChrisG: Since version 18 of SQL Server Management Studio, the SQLCMD command line interpreter has become an separate download. This command line interpreter is required for importing the ARL libraries. Please check if you have SQLCMD available (try executing SQLCMD from a command line without any options). If you don't have it available, download it from Microsoft, please.   ... View more

Hi Chris, This worked. Thanks a lot. Best,  Paweł  ... View more

Thanks for confirming and the tip, man.    Best,  Paweł ... View more