2021-07-09 11:21:49,277 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config 2021-07-09 11:21:49,308 [INFO ] Running Compliance import command line: '-processremotepackages true -it ReadersAndWriters'. 2021-07-09 11:21:49,574 [INFO ] Time: fredag 9. juli 2021 11.21.49 2021-07-09 11:21:49,574 [INFO ] FlexNet Manager Platform Version 16.0 rev 3 build 1 Copyright 2020 Flexera Software LLC 2021-07-09 11:21:50,027 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config 2021-07-09 11:21:50,027 [INFO ] No intermediate path specified, using default output path C:\ProgramData\Flexera Software\Beacon\IntermediateData. 2021-07-09 11:21:50,168 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:50,731 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:51,496 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:51,949 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:54,636 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:54,886 [INFO ] Enter ReadLicense 2021-07-09 11:21:55,949 [INFO ] Enter ProcessLicenseFile FNE LicenseBuilder 2021-07-09 11:21:55,980 [INFO ] Exit ProcessLicenseFile FNE LicenseBuilder 2021-07-09 11:21:55,996 [INFO ] Exit ReadLicense 2021-07-09 11:21:57,074 [INFO ] Did not find an importer xml file in folder 'C:\ProgramData\Flexera Software\Compliance\ImportProcedures\ObjectAdapters\'. Only procedures loaded from previous folders will be used. 2021-07-09 11:21:57,074 [INFO ] Performing import 2021-07-09 11:21:57,183 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:57,386 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:57,527 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:57,589 [DEBUG] Connection string for tenantUID= type=DW: 'Server=CMNG-SYS1;Database=FNMSdatawarehouse;Trusted_Connection=yes;' 2021-07-09 11:21:57,589 [DEBUG] Connection string for tenantUID= type=IM: 'Server=CMNG-SYS1;Database=FNMSIM;Trusted_Connection=yes;' 2021-07-09 11:21:57,605 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:57,605 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:57,605 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:57,621 [INFO ] Importing from 'FlexNet Manager Suite' [type: ManageSoft] (primary connection) 2021-07-09 11:21:57,621 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config 2021-07-09 11:21:57,621 [INFO ] Running Compliance import with "-processremotepackages true -it ReadersAndWriters" parameters 2021-07-09 11:21:57,714 [DEBUG] New task execution id: 37824 for sessionID: 8100df3f-f574-4424-9101-bed4b0fff6b4, EventTypeId: 182 2021-07-09 11:21:58,230 [DEBUG] There is no any parent beacons for beacon 2021-07-09 11:21:58,230 [DEBUG] Current Step: 3 for taskexecution ID : 37824 2021-07-09 11:21:58,246 [DEBUG] Step saved for eventTypeID: 182, Step ID: 3, Execution ID: 37824 2021-07-09 11:21:58,246 [DEBUG] Current Step: 3 for taskexecution ID : 37824 2021-07-09 11:21:58,246 [DEBUG] Step saved for eventTypeID: 182, Step ID: 4, Execution ID: 37824 2021-07-09 11:21:58,246 [DEBUG] Current Step: 3 for taskexecution ID : 37824 2021-07-09 11:21:58,246 [DEBUG] Step saved for eventTypeID: 182, Step ID: 5, Execution ID: 37824 2021-07-09 11:21:58,386 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:58,386 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:58,386 [INFO ] Reading 'ActiveDirectory' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:21:58,402 [INFO ] CreateTablesOnTarget (Execute on FNMP) 2021-07-09 11:21:58,418 [INFO ] Created temporary working tables on the FNMP database needed in succeeding processes 2021-07-09 11:21:58,464 [DEBUG] Tenant UID specified in a single tenant system: . This is probably incorrect. 2021-07-09 11:21:58,464 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:21:58,496 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,496 [INFO ] GetSites (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:21:58,511 [INFO ] Transferred 1 records 2021-07-09 11:21:58,511 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,511 [INFO ] GetSiteSubnet (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:21:58,527 [INFO ] Transferred 59 records 2021-07-09 11:21:58,527 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,527 [INFO ] PopulateSites (Execute on FNMP) 2021-07-09 11:21:58,543 [INFO ] Added 0 Active Directory sites 2021-07-09 11:21:58,543 [INFO ] Updated 1 Active Directory sites 2021-07-09 11:21:58,543 [INFO ] Deleted 0 Active Directory sites 2021-07-09 11:21:58,543 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,543 [INFO ] PopulateSubnets (Execute on FNMP) 2021-07-09 11:21:58,574 [INFO ] Added 0 Active Directory subnets 2021-07-09 11:21:58,574 [INFO ] Updated 59 Active Directory subnets 2021-07-09 11:21:58,574 [INFO ] Deleted 0 Active Directory subnets 2021-07-09 11:21:58,574 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,574 [INFO ] ImportActiveDirectoryGroup (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:21:58,621 [INFO ] Transferred 9290 records 2021-07-09 11:21:58,621 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,621 [INFO ] ImportActiveDirectoryMembers (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:21:58,886 [INFO ] Transferred 117300 records 2021-07-09 11:21:58,886 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,886 [INFO ] ImportActiveDirectoryUsers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 10.2) 2021-07-09 11:21:58,933 [INFO ] Transferred 5590 records 2021-07-09 11:21:58,933 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,933 [INFO ] ImportActiveDirectoryComputers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 11.0) 2021-07-09 11:21:58,980 [INFO ] Transferred 4949 records 2021-07-09 11:21:58,980 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,996 [INFO ] ImportActiveDirectoryDomains (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:21:58,996 [INFO ] Transferred 2 records 2021-07-09 11:21:58,996 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:58,996 [INFO ] ProcessImportedActiveDirectoryGroups (Execute on FNMP) 2021-07-09 11:21:59,121 [INFO ] Removed 0 obsolete Active Directory groups 2021-07-09 11:21:59,121 [INFO ] Updated 9290 Active Directory groups 2021-07-09 11:21:59,121 [INFO ] Added 0 Active Directory groups 2021-07-09 11:21:59,121 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,121 [INFO ] ProcessImportedActiveDirectoryMembers (Execute on FNMP) 2021-07-09 11:21:59,730 [INFO ] Removed 0 obsolete Active Directory members 2021-07-09 11:21:59,730 [INFO ] Added 0 Active Directory members 2021-07-09 11:21:59,730 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,730 [INFO ] ProcessImportedActiveDirectoryUsers (Execute on FNMP) 2021-07-09 11:21:59,824 [INFO ] Removed 0 obsolete Active Directory users 2021-07-09 11:21:59,824 [INFO ] Updated 5590 Active Directory users 2021-07-09 11:21:59,824 [INFO ] Added 0 Active Directory users 2021-07-09 11:21:59,824 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,824 [INFO ] ProcessImportedActiveDirectoryComputers (Execute on FNMP) 2021-07-09 11:21:59,902 [INFO ] Removed 0 obsolete Active Directory computers 2021-07-09 11:21:59,902 [INFO ] Updated 4949 Active Directory computers 2021-07-09 11:21:59,902 [INFO ] Added 0 Active Directory computers 2021-07-09 11:21:59,902 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,902 [INFO ] ProcessImportedActiveDirectoryDomains (Execute on FNMP) 2021-07-09 11:21:59,918 [INFO ] Removed 0 obsolete Active Directory domains 2021-07-09 11:21:59,918 [INFO ] Updated 2 Active Directory domains 2021-07-09 11:21:59,918 [INFO ] Added 0 Active Directory domains 2021-07-09 11:21:59,918 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,918 [INFO ] ImportActiveDirectoryExternalMembers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 11.0) 2021-07-09 11:21:59,933 [INFO ] Transferred 424 records 2021-07-09 11:21:59,933 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,933 [INFO ] CleanupSourceTemporaryTables (Execute on Source) 2021-07-09 11:21:59,933 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,933 [INFO ] ProcessImportedActiveDirectoryExternalMember (Execute on FNMP) (VersionFrom: 11.0) 2021-07-09 11:21:59,996 [INFO ] Removed 0 obsolete Active Directory external member objects 2021-07-09 11:21:59,996 [INFO ] Added 0 Active Directory external member objects 2021-07-09 11:21:59,996 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:21:59,996 [INFO ] CleanupTemporaryTables (Execute on FNMP) 2021-07-09 11:22:00,011 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,011 [INFO ] Reading data for 'ActiveDirectory' successfully processed in 1 second. 2021-07-09 11:22:00,027 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_ActiveDirectory_ALL 2021-07-09 11:22:00,027 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:00,027 [INFO ] Reading 'Computer' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:00,027 [INFO ] GetAdditionalApplicationLocks (Execute on FNMP) 2021-07-09 11:22:00,027 [INFO ] Created additional application lock Writer_Source_AdditionalApplicationLock_ALL 2021-07-09 11:22:00,027 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,027 [INFO ] CreateTablesOnSource (Execute on Source) 2021-07-09 11:22:00,027 [INFO ] Created temporary working tables on the source database needed in succeeding processes 2021-07-09 11:22:00,027 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,027 [INFO ] PrepareDomainsForImport (Execute on Source) 2021-07-09 11:22:00,043 [INFO ] Found 3 Domains in the source database 2021-07-09 11:22:00,043 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,043 [INFO ] CreateTablesOnTarget (Execute on FNMP) 2021-07-09 11:22:00,043 [INFO ] Created temporary working tables on the FNMP database needed in succeeding processes 2021-07-09 11:22:00,043 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,043 [INFO ] GetManageSoftDomains (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:00,074 [INFO ] Transferred 3 records 2021-07-09 11:22:00,074 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,074 [INFO ] InsertUpdateImportedDomain (Execute on FNMP) 2021-07-09 11:22:00,089 [INFO ] Removed 0 Domains in ImportedDomain staging table that no longer exist from source database 2021-07-09 11:22:00,089 [INFO ] Added 0 Domains in ImportedDomain staging table from source database 2021-07-09 11:22:00,089 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,089 [INFO ] CleanupDomainTemporaryTablesOnTarget (Execute on FNMP) 2021-07-09 11:22:00,089 [INFO ] Removed temporary working tables on the FNMP database 2021-07-09 11:22:00,089 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,089 [INFO ] CreateTemporaryUserTables (Execute on FNMP) 2021-07-09 11:22:00,089 [INFO ] Created temporary working tables on FNMP database needed for succeeding processes 2021-07-09 11:22:00,089 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,089 [INFO ] ImportUsers (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:00,183 [INFO ] Transferred 5590 records 2021-07-09 11:22:00,183 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,183 [INFO ] InsertUpdateUsers (Execute on FNMP) 2021-07-09 11:22:00,371 [INFO ] Removed 0 Users in ImportedUser staging table that no longer exist from source database 2021-07-09 11:22:00,371 [INFO ] Updated 0 Users in ImportedUser staging table that have changed in source database 2021-07-09 11:22:00,371 [INFO ] Added 0 new Users into ImportedUser staging table that exist in source database 2021-07-09 11:22:00,371 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,371 [INFO ] ImportLicenseUsers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.4) 2021-07-09 11:22:00,371 [INFO ] Transferred 0 records 2021-07-09 11:22:00,371 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,371 [INFO ] CreateLicenseUserStringMappings (Execute on FNMP) 2021-07-09 11:22:00,386 [INFO ] Removed 0 text mapping records for LicenseUser external IDs in ImportedStringMapping staging table 2021-07-09 11:22:00,386 [INFO ] Added 0 text mapping records for License user external IDs in ImportedStringMapping staging table 2021-07-09 11:22:00,386 [INFO ] Updated 0 text mapping records for License user external IDs in ImportedStringMapping staging table 2021-07-09 11:22:00,386 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,386 [INFO ] InsertUpdateLicenseUsers (Execute on FNMP) 2021-07-09 11:22:00,402 [INFO ] Removed 0 License Users in ImportedLicenseUser staging table that no longer exist in source database 2021-07-09 11:22:00,402 [INFO ] Updated 0 License Users in ImportedLicenseUser staging table that have changed in source database 2021-07-09 11:22:00,402 [INFO ] Added 0 new License Users in ImportedLicenseUser staging table that exist in source database 2021-07-09 11:22:00,402 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,402 [INFO ] CleanupUserTemporaryTablesOnTarget (Execute on FNMP) 2021-07-09 11:22:00,417 [INFO ] Removed temporary working tables in FNMP database 2021-07-09 11:22:00,417 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,417 [INFO ] CreateTemporaryComputerTablesOnSource (Execute on Source) 2021-07-09 11:22:00,417 [INFO ] Created temporary working tables in source database needed for succeeding processes 2021-07-09 11:22:00,417 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,417 [INFO ] CreateTemporaryComputerTables (Execute on FNMP) 2021-07-09 11:22:00,480 [INFO ] Created temporary working tables in FNMP database needed for succeeding processes 2021-07-09 11:22:00,480 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,480 [INFO ] GetKnownComputers (Transfer from FNMP to source 'FlexNet Manager Suite') (VersionFrom: 12.3) 2021-07-09 11:22:00,527 [INFO ] Transferred 287 records 2021-07-09 11:22:00,527 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,527 [INFO ] BuildRelevantComputerList (Execute on Source) (VersionFrom: 10.2) 2021-07-09 11:22:00,542 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:00,542 [INFO ] Found 57 Computers in the source database that either have changed or added since the last import 2021-07-09 11:22:00,542 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,542 [INFO ] ForceUpdateOfAllComputers (Execute on Source) (VersionFrom: 12.0) 2021-07-09 11:22:00,542 [INFO ] This reader is for full import, and was not executed because the current run is a differential import. 2021-07-09 11:22:00,542 [INFO ] Completed in 0 seconds. 2021-07-09 11:22:00,542 [INFO ] BuildFabricatedComputerList (Execute on Source) (VersionFrom: 12.3) 2021-07-09 11:22:00,558 [INFO ] Found 0 Computers in the source database created from partition inventory 2021-07-09 11:22:00,558 [INFO ] Found 56 Computers in the source database with hardware inventory history 2021-07-09 11:22:00,558 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,558 [INFO ] GetDeletedComputerList (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:00,558 [INFO ] Transferred 0 records 2021-07-09 11:22:00,558 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,558 [INFO ] ReadComputerInventoryDates (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 13.5) 2021-07-09 11:22:00,574 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:00,574 [INFO ] Transferred 57 records 2021-07-09 11:22:00,574 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,574 [INFO ] ReadComputerDomains (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 9.3) 2021-07-09 11:22:00,683 [INFO ] Transferred 57 records 2021-07-09 11:22:00,683 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,683 [INFO ] CleanComputerDomains (Execute on FNMP) 2021-07-09 11:22:00,699 [INFO ] Cleaned 57 Computer AD Domains into DNS domain names 2021-07-09 11:22:00,699 [INFO ] Discarded 0 Computer Domains that are considered duplicate 2021-07-09 11:22:00,699 [INFO ] Cleaned 0 default MANAGESOFT Computer domains into empty domains 2021-07-09 11:22:00,699 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,699 [INFO ] ReadComputers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:00,714 [INFO ] Transferred 57 records 2021-07-09 11:22:00,714 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,714 [INFO ] ReadManufacturer (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:00,730 [INFO ] Transferred 56 records 2021-07-09 11:22:00,730 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,730 [INFO ] ReadModel (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:00,730 [INFO ] Transferred 56 records 2021-07-09 11:22:00,730 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,730 [INFO ] ReadLastLoggedOnUser (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:00,746 [INFO ] Transferred 0 records 2021-07-09 11:22:00,746 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,746 [INFO ] ReadSerialNumber (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 14.0) 2021-07-09 11:22:00,933 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:00,949 [INFO ] Transferred 56 records 2021-07-09 11:22:00,949 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,949 [INFO ] ReadHostID (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:00,996 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:00,996 [INFO ] Transferred 56 records 2021-07-09 11:22:00,996 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:00,996 [INFO ] ReadDiskInfo (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,027 [INFO ] Transferred 0 records 2021-07-09 11:22:01,027 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,027 [INFO ] ReadProcessorInfo (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:01,043 [INFO ] Transferred 56 records 2021-07-09 11:22:01,043 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,043 [INFO ] ReadCoreInfo (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:01,043 [INFO ] Transferred 56 records 2021-07-09 11:22:01,043 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,043 [INFO ] ReadDisplayAdapters (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,058 [INFO ] Transferred 0 records 2021-07-09 11:22:01,058 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,058 [INFO ] ReadNetworkCards (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,167 [INFO ] Transferred 0 records 2021-07-09 11:22:01,167 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,167 [INFO ] CleanNetworkCards (Execute on FNMP) 2021-07-09 11:22:01,167 [INFO ] Transformed multiple MAC Addresses per computer into delimited text 2021-07-09 11:22:01,167 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,167 [INFO ] ReadIPAddresses SourceToTarget (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,277 [INFO ] Transferred 0 records 2021-07-09 11:22:01,277 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,277 [INFO ] ReadIPAddresses ExecuteOnTarget (Execute on FNMP) 2021-07-09 11:22:01,277 [INFO ] Transformed multiple IP Addresses per computer into delimited text 2021-07-09 11:22:01,277 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,277 [INFO ] CreateVDITempTables (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,292 [INFO ] Created temporary working tables in target database needed for VDI data 2021-07-09 11:22:01,292 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,292 [INFO ] TransferVDIDeviceDataToTargetDatabase (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 9.3) 2021-07-09 11:22:01,292 [INFO ] Transferred 0 records 2021-07-09 11:22:01,292 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,292 [INFO ] TransferVDIAccessDataToTargetDatabase (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 10.2) 2021-07-09 11:22:01,292 [INFO ] Transferred 0 records 2021-07-09 11:22:01,292 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,292 [INFO ] UpdateVDIUserDataInTargetDatabase (Execute on FNMP) (VersionFrom: 10.2) 2021-07-09 11:22:01,402 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,402 [INFO ] TransferVDIEndpointAccessDataToTargetDatabase (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,402 [INFO ] Transferred 0 records 2021-07-09 11:22:01,402 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,402 [INFO ] ImportVDIDeviceInformation (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,417 [INFO ] Removed 0 VDI devices that no longer exist in the source database 2021-07-09 11:22:01,417 [INFO ] Added 0 VDI devices from the source database 2021-07-09 11:22:01,417 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,417 [INFO ] ImportVDIUserInformation (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,433 [INFO ] Removed 0 VDI ACL users from the source database 2021-07-09 11:22:01,433 [INFO ] Updated scan time for 0 VDI ACL users in the source database 2021-07-09 11:22:01,433 [INFO ] Added 0 VDI ACL users from the source database 2021-07-09 11:22:01,433 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,433 [INFO ] ImportVDIEndpointAccessInformation (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,449 [INFO ] Removed 0 VDI end-point access records that are too old. 2021-07-09 11:22:01,449 [INFO ] Removed 0 incoming VDI end-point access records that are too old. 2021-07-09 11:22:01,449 [INFO ] Added 0 new VDI end-point access records from the source database. 2021-07-09 11:22:01,449 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,449 [INFO ] CreateEndpointDevices (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,480 [INFO ] Removed 0 unrequired remote devices from the VDI data in the source database. 2021-07-09 11:22:01,480 [INFO ] Added 0 end-point devices from the VDI data in the source database. 2021-07-09 11:22:01,480 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,480 [INFO ] UpdateComplianceComputerTypesIfSerialExists (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,496 [INFO ] Updated 0 remote end-point devices to be real devices 2021-07-09 11:22:01,496 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,496 [INFO ] CreateImportedVDITemplates (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,542 [INFO ] Removed 0 obsolete VDI templates from the source database. 2021-07-09 11:22:01,542 [INFO ] Added 0 VDI templates from the source database. 2021-07-09 11:22:01,542 [INFO ] Removed 0 obsolete VDI templates ImportedComputer records from the source database. 2021-07-09 11:22:01,542 [INFO ] Added 0 ImportedComputer VDI template records from the source database. 2021-07-09 11:22:01,542 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,542 [INFO ] ClearVDITempTables (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:01,542 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,542 [INFO ] ReadOperatingSystems (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,574 [INFO ] Transferred 56 records 2021-07-09 11:22:01,574 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,574 [INFO ] FetchVersioningInformationForOperatingSystemNames (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,714 [INFO ] Transferred 56 records 2021-07-09 11:22:01,714 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,714 [INFO ] IncreaseComputerOperatingSystemVersionVisiblity (Execute on FNMP) 2021-07-09 11:22:01,730 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,730 [INFO ] ReadServicePacks (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,746 [INFO ] Transferred 0 records 2021-07-09 11:22:01,746 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,746 [INFO ] ReadComputerMemory (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,792 [INFO ] Transferred 56 records 2021-07-09 11:22:01,792 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,792 [INFO ] ReadChassisTypes (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,808 [INFO ] Transferred 0 records 2021-07-09 11:22:01,808 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,808 [INFO ] ReadILMTAgentID (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,902 [INFO ] Transferred 0 records 2021-07-09 11:22:01,902 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,902 [INFO ] ReadIdentifyingNumber (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,933 [INFO ] Transferred 56 records 2021-07-09 11:22:01,933 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,933 [INFO ] ReadHostType (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:01,949 [INFO ] Transferred 0 records 2021-07-09 11:22:01,949 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,949 [INFO ] ReadComplianceComputerTypeID (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:01,964 [INFO ] Transferred 56 records 2021-07-09 11:22:01,964 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,964 [INFO ] ReadComplianceComputerTypeIDContainers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:01,980 [INFO ] Transferred 0 records 2021-07-09 11:22:01,980 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:01,980 [INFO ] ReadUUID (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:02,027 [INFO ] Transferred 56 records 2021-07-09 11:22:02,027 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,027 [INFO ] CleanseUUIDs (Execute on FNMP) 2021-07-09 11:22:02,027 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,027 [INFO ] ReadAgentEvents (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:02,042 [INFO ] Transferred 0 records 2021-07-09 11:22:02,042 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,042 [INFO ] CalculateAgentEventSummary (Execute on FNMP) 2021-07-09 11:22:02,058 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,058 [INFO ] Use information from legacy agent versions for host identifier details (Execute on FNMP) 2021-07-09 11:22:02,074 [INFO ] Updated 0 AIX using legacy inventory agent details 2021-07-09 11:22:02,074 [INFO ] Updated 0 SunOS using legacy inventory agent details 2021-07-09 11:22:02,074 [INFO ] Updated 0 HP-UX using legacy inventory agent details 2021-07-09 11:22:02,074 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,074 [INFO ] Find deleted computers when disconnected (Execute on FNMP) 2021-07-09 11:22:02,074 [INFO ] This reader only executes when the connection is in disconnected mode. 2021-07-09 11:22:02,074 [INFO ] Completed in 0 seconds. 2021-07-09 11:22:02,074 [INFO ] Find legacy partitioned host computer records for deletion (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:02,074 [INFO ] Found 0 Computers in ImportedComputer that are legacy partitioned host records. 2021-07-09 11:22:02,074 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,074 [INFO ] Read metadata blob Json data for computer (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:02,105 [INFO ] Transferred 0 records 2021-07-09 11:22:02,105 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,105 [INFO ] PopulateComputerResults (Execute on FNMP) 2021-07-09 11:22:02,214 [INFO ] Removed 0 Computers in ImportedComputer staging table that no longer exist from source database 2021-07-09 11:22:02,214 [INFO ] Updated 57 Computers in ImportedComputer staging table that have changed in the source database 2021-07-09 11:22:02,214 [INFO ] Added 0 Computers in ImportedComputer staging table that are new in source database 2021-07-09 11:22:02,214 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,214 [INFO ] ProcessCSPMetadataJsonBlob (Execute on FNMP) 2021-07-09 11:22:02,636 [INFO ] Processing ImportedComputers' CSPMetadataJsonBlob. 2021-07-09 11:22:02,667 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:02,683 [INFO ] Updating ImportedCloudServiceInstance staging tables. 2021-07-09 11:22:02,699 [INFO ] Finished processing ImportedComputer CSPMetdataJsonBlobs. 2021-07-09 11:22:02,699 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,699 [INFO ] CleanupComputerTemporaryTablesOnSource (Execute on Source) 2021-07-09 11:22:02,699 [INFO ] Removed temporary working tables on the source database 2021-07-09 11:22:02,699 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,699 [INFO ] CleanupComputerTemporaryTablesOnTarget (Execute on FNMP) 2021-07-09 11:22:02,761 [INFO ] Removed temporary working tables on the FNMP database 2021-07-09 11:22:02,761 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,761 [INFO ] Reading data for 'Computer' successfully processed in 2 seconds. 2021-07-09 11:22:02,761 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_Computer_ALL 2021-07-09 11:22:02,761 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:02,761 [INFO ] Reading 'VirtualMachine' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:02,761 [INFO ] CleanImportedVMPool (Execute on FNMP) 2021-07-09 11:22:02,792 [INFO ] Removed 883 VM Pools in ImportedVMPool staging table 2021-07-09 11:22:02,792 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,792 [INFO ] ReadVMPools (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:02,839 [INFO ] Transferred 883 records 2021-07-09 11:22:02,839 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,839 [INFO ] SetParentPoolTypeOnImportedVMPool (Execute on FNMP) 2021-07-09 11:22:02,871 [INFO ] Synchronized 883 VM Pool Types into their parent host Pool Types 2021-07-09 11:22:02,871 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,871 [INFO ] RemoveInvalidAsciiFromImportedVMPool (Execute on FNMP) 2021-07-09 11:22:02,917 [INFO ] Updated 883 VM Pools in ImportedVMPool staging table to remove the unsupported characters 2021-07-09 11:22:02,917 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,917 [INFO ] CleanImportedVirtualMachine (Execute on FNMP) 2021-07-09 11:22:02,933 [INFO ] Removed 469 Virtual Machines in ImportedVirtualMachine staging table 2021-07-09 11:22:02,933 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:02,933 [INFO ] ReadVirtualMachines (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:03,233 [INFO ] Transferred 469 records 2021-07-09 11:22:03,233 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,233 [INFO ] SetPoolTypeOnImportedVirtualMachine (Execute on FNMP) 2021-07-09 11:22:03,264 [INFO ] Updated 469 Virtual Machines Pool Types in ImportedVirtualMachine staging table 2021-07-09 11:22:03,264 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,264 [INFO ] CleanImportedVMHostProperty (Execute on FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:03,264 [INFO ] Removed 56 Virtual Machine host records from the staging table 2021-07-09 11:22:03,264 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,264 [INFO ] InsertImportedVMHostProperty (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:03,343 [INFO ] Transferred 56 records 2021-07-09 11:22:03,343 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,343 [INFO ] CleanImportedVMHostDatastore (Execute on FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:03,343 [INFO ] Removed 62 Virtual Machine host datastore records from the staging table 2021-07-09 11:22:03,343 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,343 [INFO ] InsertImportedVMHostDatastore (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:03,405 [INFO ] Transferred 62 records 2021-07-09 11:22:03,405 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,405 [INFO ] CreateTemporaryPartitionTablesOnSource (Execute on Source) 2021-07-09 11:22:03,421 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,421 [INFO ] CreateTemporaryPartitionTables (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,436 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,436 [INFO ] PopulateVirtualComputerSystems (Execute on Source) 2021-07-09 11:22:03,468 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,468 [INFO ] ReadPartitions (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,499 [INFO ] Transferred 0 records 2021-07-09 11:22:03,499 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,499 [INFO ] ReadIdentifyingNumber (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:03,627 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:03,627 [INFO ] Transferred 230 records 2021-07-09 11:22:03,627 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,627 [INFO ] Use information from legacy agent versions for partitions (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,627 [INFO ] Updated 0 computer partition number using legacy inventory agent details for LPAR 2021-07-09 11:22:03,627 [INFO ] Updated 0 computer partition ID using legacy inventory agent details for nPar, vPar and Zone 2021-07-09 11:22:03,627 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,627 [INFO ] IdentifyPartitionHosts (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,643 [INFO ] Found 0 Partition Hosts from source database 2021-07-09 11:22:03,643 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,643 [INFO ] UpdatePartitionHosts (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,643 [INFO ] Updated 0 existing Partition Hosts in ImportedComputer staging table 2021-07-09 11:22:03,643 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,643 [INFO ] CreatePartitionVMsTempFromGlobalZone (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:03,659 [INFO ] Transferred 0 records 2021-07-09 11:22:03,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,659 [INFO ] PopulatePartitionFromComputerResource (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,659 [INFO ] Transferred 0 records 2021-07-09 11:22:03,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,659 [INFO ] PopulateExternalHostIDFromComputerResource (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,659 [INFO ] CreatePartitionVMs (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,674 [INFO ] Added 0 new Virtual Machines into ImportedVirtualMachine staging table that exist from source database 2021-07-09 11:22:03,674 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,674 [INFO ] CreatePartitionVMsFromGlobalZone (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,706 [INFO ] Added 0 new Virtual Machines into ImportedVirtualMachine staging table using zone information from global zone 2021-07-09 11:22:03,706 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,706 [INFO ] PopulatePoolFromComputerResource (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,706 [INFO ] Transferred 0 records 2021-07-09 11:22:03,706 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,706 [INFO ] CreatePartitionPools (Execute on FNMP) (VersionFrom: 12.3) 2021-07-09 11:22:03,721 [INFO ] Added 0 pools to ImportedVMPool staging table from source datasource 2021-07-09 11:22:03,721 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,721 [INFO ] CreateTemporaryClusterTables (Execute on FNMP) 2021-07-09 11:22:03,737 [INFO ] Created temporary working tables in FNMP database needed for succeeding processes 2021-07-09 11:22:03,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,737 [INFO ] ReadClusters (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:03,752 [INFO ] Transferred 52 records 2021-07-09 11:22:03,752 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,752 [INFO ] SetClusterTypeIDs (Execute on FNMP) 2021-07-09 11:22:03,752 [INFO ] Matched 52 Cluster types between source and FNMP database 2021-07-09 11:22:03,752 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,752 [INFO ] ReadClusterNodes (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:03,768 [INFO ] Transferred 52 records 2021-07-09 11:22:03,768 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,768 [INFO ] ReadClusterGroups (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:03,799 [INFO ] Transferred 260 records 2021-07-09 11:22:03,799 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,799 [INFO ] SetClusterGroupTypeIDs (Execute on FNMP) 2021-07-09 11:22:03,799 [INFO ] Matched 260 Cluster group types from the source database with Cluster types in FNMP database 2021-07-09 11:22:03,799 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:03,799 [INFO ] ReadClusterGroupMembers (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:04,159 [INFO ] Transferred 6860 records 2021-07-09 11:22:04,159 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,159 [INFO ] ReadClusterAffinityRules (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:04,174 [INFO ] Transferred 40 records 2021-07-09 11:22:04,174 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,174 [INFO ] CreateClusterStringMappings (Execute on FNMP) 2021-07-09 11:22:04,190 [INFO ] Removed 0 text mapping records for Cluster external IDs in ImportedStringMapping staging table 2021-07-09 11:22:04,190 [INFO ] Added 0 text mapping records for Cluster external IDs in ImportedStringMapping staging table 2021-07-09 11:22:04,206 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,206 [INFO ] CreateClusterGroupStringMappings (Execute on FNMP) 2021-07-09 11:22:04,237 [INFO ] Removed 0 text mapping records for Cluster Group external IDs in ImportedStringMapping staging table 2021-07-09 11:22:04,237 [INFO ] Added 0 text mapping records for Cluster Group external IDs in ImportedStringMapping staging table 2021-07-09 11:22:04,237 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,237 [INFO ] WriteImportedClusters (Execute on FNMP) 2021-07-09 11:22:04,237 [INFO ] Removed 8 Cluster records in ImportedCluster staging table 2021-07-09 11:22:04,237 [INFO ] Added 8 Cluster records in ImportedCluster staging table 2021-07-09 11:22:04,237 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,237 [INFO ] WriteImportedClusterNodes (Execute on FNMP) 2021-07-09 11:22:04,252 [INFO ] Removed 52 Cluster Node records in ImportedClusterNode staging table 2021-07-09 11:22:04,252 [INFO ] Added 52 Cluster Node records in ImportedClusterNode staging table 2021-07-09 11:22:04,252 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,252 [INFO ] WriteImportedClusterGroups (Execute on FNMP) 2021-07-09 11:22:04,268 [INFO ] Removed 13 Cluster Group records in ImportedClusterGroup staging table 2021-07-09 11:22:04,268 [INFO ] Added 13 Cluster Group records in ImportedClusterGroup staging table 2021-07-09 11:22:04,268 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,268 [INFO ] WriteImportedClusterGroupMembers (Execute on FNMP) 2021-07-09 11:22:04,377 [INFO ] Removed 343 Cluster Group Member records in ImportedClusterGroupMember staging table 2021-07-09 11:22:04,377 [INFO ] Added 343 Cluster Group Member records in ImportedClusterGroupMember staging table 2021-07-09 11:22:04,377 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,377 [INFO ] WriteImportedClusterAffinityRules (Execute on FNMP) 2021-07-09 11:22:04,409 [INFO ] Removed 2 Cluster Host Affinity Rule records in ImportedClusterHostAffinityRule staging table 2021-07-09 11:22:04,409 [INFO ] Added 2 Cluster Host Affinity Rule records in ImportedClusterHostAffinityRule staging table 2021-07-09 11:22:04,409 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,409 [INFO ] ReleaseAdditionalApplicationLocks (Execute on FNMP) 2021-07-09 11:22:04,409 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,409 [INFO ] Reading data for 'VirtualMachine' successfully processed in 1 second. 2021-07-09 11:22:04,409 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_VirtualMachine_ALL 2021-07-09 11:22:04,409 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:04,409 [INFO ] Reading 'Container' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:04,409 [INFO ] CreateTemporaryTablesOnSource (Execute on Source) (VersionFrom: 14.3) 2021-07-09 11:22:04,424 [INFO ] Prepared session environment in source database needed for succeeding processes 2021-07-09 11:22:04,424 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,424 [INFO ] CreateTemporaryTablesOnTarget (Execute on FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:04,424 [INFO ] Prepared session environment in target database needed for succeeding processes 2021-07-09 11:22:04,424 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,424 [INFO ] BuildRelevantContainers (Execute on Source) (VersionFrom: 14.3) 2021-07-09 11:22:04,440 [INFO ] Found 0 containers in the source database 2021-07-09 11:22:04,440 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,440 [INFO ] BuildRelevantContainerImages (Execute on Source) (VersionFrom: 14.3) 2021-07-09 11:22:04,440 [INFO ] Found 0 container images in the source database that either have changed or added since the last import 2021-07-09 11:22:04,440 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,440 [INFO ] ReadContainerImages (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:04,456 [INFO ] Transferred 0 records 2021-07-09 11:22:04,456 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,456 [INFO ] ReadContainerInstances (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:04,518 [INFO ] Transferred 0 records 2021-07-09 11:22:04,518 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,518 [INFO ] PopulateImportedContainerImage (Execute on FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:04,534 [INFO ] Removed 0 images in ImportedContainerImage staging table that no longer exist in the source database 2021-07-09 11:22:04,534 [INFO ] Updated 0 containers in the ImportedContainerImage staging table that either have been changed since the last import 2021-07-09 11:22:04,534 [INFO ] Imported 0 containers in the ImportedContainerImage staging table that either have been added since the last import 2021-07-09 11:22:04,534 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,534 [INFO ] PopulateImportedContainerInstance (Execute on FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:04,549 [INFO ] Removed 0 containers in ImportedContainerInstance staging table that no longer exist in the source database 2021-07-09 11:22:04,549 [INFO ] Updated 0 containers in the ImportedContainerInstance staging table that either have been changed since the last import 2021-07-09 11:22:04,549 [INFO ] Imported 0 containers in the ImportedContainerInstance staging table that either have been added since the last import 2021-07-09 11:22:04,549 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,549 [INFO ] CleanupTemporaryTablesOnSource (Execute on Source) (VersionFrom: 14.3) 2021-07-09 11:22:04,565 [INFO ] Cleaned up temporary working tables from the source database 2021-07-09 11:22:04,565 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,565 [INFO ] CleanupTemporaryTablesOnTarget (Execute on FNMP) (VersionFrom: 14.3) 2021-07-09 11:22:04,565 [INFO ] Cleaned up temporary working tables from the target database 2021-07-09 11:22:04,565 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,565 [INFO ] Reading data for 'Container' successfully processed in 0 seconds. 2021-07-09 11:22:04,565 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_Container_ALL 2021-07-09 11:22:04,565 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:04,565 [INFO ] Reading 'Evidence' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:04,565 [INFO ] CreateApplicationFileTempTables (Execute on Source) 2021-07-09 11:22:04,581 [INFO ] Created temporary working tables on source database needed for succeeding processes 2021-07-09 11:22:04,581 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,581 [INFO ] PrepareForOptionalFileEvidenceOnSource (Execute on Source) 2021-07-09 11:22:04,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,596 [INFO ] PrepareForOptionalFileEvidenceOnTarget (Execute on FNMP) 2021-07-09 11:22:04,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,596 [INFO ] InsertIntoFileTempFileEvidence (Transfer from FNMP to source 'FlexNet Manager Suite') 2021-07-09 11:22:04,596 [INFO ] Transferred 0 records 2021-07-09 11:22:04,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,596 [INFO ] InsertIntoFileTempApplicationFile (Execute on Source) 2021-07-09 11:22:04,596 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,596 [INFO ] InsertIntoFileTempApplicationFileWild (Execute on Source) 2021-07-09 11:22:04,612 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,612 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,612 [INFO ] CreateIndexOnFileTempApplicationFile (Execute on Source) 2021-07-09 11:22:04,612 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,612 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,612 [INFO ] BuildCompanyAndFileDescriptionLists (Execute on Source) 2021-07-09 11:22:04,627 [INFO ] Found 1 Company names in source database 2021-07-09 11:22:04,627 [INFO ] Found 1 File Descriptions in source database 2021-07-09 11:22:04,627 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,627 [INFO ] GetMaxUsagePeriod (Transfer from FNMP to source 'FlexNet Manager Suite') 2021-07-09 11:22:04,659 [INFO ] Transferred 1 records 2021-07-09 11:22:04,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,659 [INFO ] Set default usage period for disconnected import (Execute on Source) 2021-07-09 11:22:04,659 [INFO ] This reader only executes when the connection is in disconnected mode. 2021-07-09 11:22:04,659 [INFO ] Completed in 0 seconds. 2021-07-09 11:22:04,659 [INFO ] IncludeUsageCompanyAndFileDescriptionLists (Execute on Source) 2021-07-09 11:22:04,690 [INFO ] Max usage period is 3. 2021-07-09 11:22:04,690 [INFO ] Found 0 Company names from usage data in source database 2021-07-09 11:22:04,690 [INFO ] Found 0 File Descriptions from usage data in source database 2021-07-09 11:22:04,690 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,690 [INFO ] LoadSoftwareFileNames (Execute on Source) 2021-07-09 11:22:04,690 [INFO ] Found 33 relevant File Names in source database 2021-07-09 11:22:04,690 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,690 [INFO ] MatchSoftwareFileNamesWithoutWildcards (Execute on Source) 2021-07-09 11:22:04,706 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,706 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,706 [INFO ] MatchSoftwareFileNamesWithWildcards (Execute on Source) 2021-07-09 11:22:04,706 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,706 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,706 [INFO ] InsertRelevantSoftwareFiles (Execute on Source) 2021-07-09 11:22:04,706 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,706 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,706 [INFO ] ReadRelevantUnixFiles (Execute on Source) 2021-07-09 11:22:04,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,737 [INFO ] CreateIndexOnUnixSoftwareFile (Execute on Source) 2021-07-09 11:22:04,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,737 [INFO ] InsertRelevantUnixFilesWithoutWildcards (Execute on Source) 2021-07-09 11:22:04,737 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,737 [INFO ] InsertRelevantUnixFilesWithWildcards (Execute on Source) 2021-07-09 11:22:04,737 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,737 [INFO ] InsertRelevantUsageFilesWithoutWildcards (Execute on Source) 2021-07-09 11:22:04,737 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,737 [INFO ] InsertRelevantUsageFilesWithWildcards (Execute on Source) 2021-07-09 11:22:04,737 [INFO ] Step not executed as optional readers are included 2021-07-09 11:22:04,752 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,752 [INFO ] InsertOptionalSoftwareFilesIntoTempRelevantSoftwareFile (Execute on Source) 2021-07-09 11:22:04,784 [INFO ] Found 0 File Evidence in the source that have no matching records in FNMP 2021-07-09 11:22:04,784 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,784 [INFO ] InsertOptionalUnixFilesIntoTempRelevantSoftwareFile (Execute on Source) 2021-07-09 11:22:04,799 [INFO ] Found 0 Unix File Evidence in the source that have no matching records in FNMP 2021-07-09 11:22:04,799 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,799 [INFO ] InsertOptionalUsageFiles (Execute on Source) 2021-07-09 11:22:04,846 [INFO ] Found 0 File Evidence on usage data in the source that have no matching records in FNMP 2021-07-09 11:22:04,846 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,846 [INFO ] CreateTemporaryFileEvidenceTables (Execute on FNMP) 2021-07-09 11:22:04,846 [INFO ] Created temporary working tables on FNMP needed for succeeding processes 2021-07-09 11:22:04,846 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,846 [INFO ] ImportIntoManageSoftFiles (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:04,862 [INFO ] Transferred 0 records 2021-07-09 11:22:04,862 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,862 [INFO ] ImportIntoTempSoftwareFile (Execute on Source) 2021-07-09 11:22:04,877 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,877 [INFO ] ImportUnixFilesIntoSoftwareFile (Execute on Source) 2021-07-09 11:22:04,877 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,877 [INFO ] ImportIntoSoftwareFile (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:04,893 [INFO ] Transferred 0 records 2021-07-09 11:22:04,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,893 [INFO ] ImportIntoFileSoftwareVersion (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:04,893 [INFO ] Transferred 3 records 2021-07-09 11:22:04,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,893 [INFO ] ImportIntoFileSoftwareFilePath (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:04,893 [INFO ] Transferred 15 records 2021-07-09 11:22:04,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,893 [INFO ] CreateIndexesOnFileTempTables (Execute on FNMP) 2021-07-09 11:22:04,909 [INFO ] Created table indexes on temporary working tables to improve performance 2021-07-09 11:22:04,909 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,909 [INFO ] GetExternalFileIDs (Execute on FNMP) 2021-07-09 11:22:04,909 [INFO ] Mapped 0 external File Evidence IDs 2021-07-09 11:22:04,924 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,924 [INFO ] CreateIndexOnTempImportedFileEvidence (Execute on FNMP) 2021-07-09 11:22:04,924 [INFO ] Created table indexes on temporary working tables to improve performance 2021-07-09 11:22:04,924 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,924 [INFO ] InsertIntoImportedFileEvidence (Execute on FNMP) 2021-07-09 11:22:04,940 [INFO ] Added 0 new File Evidence records into ImportedFileEvidence staging table that exist in source database 2021-07-09 11:22:04,940 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,940 [INFO ] UpdateTempImportedFileEvidence (Execute on FNMP) 2021-07-09 11:22:04,956 [INFO ] Mapped 0 external File Evidence IDs 2021-07-09 11:22:04,956 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,956 [INFO ] DeleteFromImportedInstalledFileEvidence - From DeleteComputers (Execute on FNMP) 2021-07-09 11:22:04,987 [INFO ] Identified 0 ImportedInstalledFileEvidence records to be deleted 2021-07-09 11:22:04,987 [INFO ] Removed 0 ImportedInstalledFileEvidence records in ImportedInstalledFileEvidence staging table 2021-07-09 11:22:04,987 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:04,987 [INFO ] DeleteFromImportedInstalledFileEvidence - From Deleted File Evidence (Execute on FNMP) 2021-07-09 11:22:05,018 [INFO ] Identified 0 ImportedInstalledFileEvidence records to be deleted 2021-07-09 11:22:05,018 [INFO ] Removed 0 ImportedInstalledFileEvidence records in ImportedInstalledFileEvidence staging table 2021-07-09 11:22:05,018 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,018 [INFO ] ImportIntoImportedInstalledFileEvidence (Execute on FNMP) 2021-07-09 11:22:05,034 [INFO ] Added 0 new installed File Evidence records into ImportedInstalledFileEvidence staging table that exist in source database 2021-07-09 11:22:05,034 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,034 [INFO ] InsertIntoImportedInstalledFileEvidencePath (Execute on FNMP) 2021-07-09 11:22:05,049 [INFO ] Removed 0 File Evidence path records from ImportedInstalledFileEvidencePath staging table that do not exist in source database 2021-07-09 11:22:05,049 [INFO ] Added 0 new installed File Evidence path records into ImportedInstalledFileEvidencePath staging table that exist in source database 2021-07-09 11:22:05,049 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,049 [INFO ] CleanupFileTemporaryTablesOnSource (Execute on Source) 2021-07-09 11:22:05,049 [INFO ] Removed temporary working tables on source database 2021-07-09 11:22:05,049 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,049 [INFO ] CleanupFileTemporaryTablesOnTarget (Execute on FNMP) 2021-07-09 11:22:05,065 [INFO ] Removed temporary working tables on FNMP database 2021-07-09 11:22:05,065 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,065 [INFO ] Create Temp Table On Source (Execute on Source) (VersionFrom: 12.0) 2021-07-09 11:22:05,065 [INFO ] Created temporary working tables on source database needed for succeeding processes 2021-07-09 11:22:05,065 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,065 [INFO ] SendAccessEvidenceHistorySettingToSource (Transfer from FNMP to source 'FlexNet Manager Suite') (VersionFrom: 12.0) 2021-07-09 11:22:05,065 [INFO ] Transferred 1 records 2021-07-09 11:22:05,065 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,065 [INFO ] DeleteAgedDataFromSource (Execute on Source) (VersionFrom: 12.0) 2021-07-09 11:22:05,112 [INFO ] Number of days to keep access evidence: 90 days 2021-07-09 11:22:05,112 [INFO ] Deleted 0 access occurrences which are older than 90 days 2021-07-09 11:22:05,112 [INFO ] Deleted 0 client access evidences which has all the occurrences deleted 2021-07-09 11:22:05,112 [INFO ] Deleted 0 accessing devices which which does not have any evidences associated 2021-07-09 11:22:05,112 [INFO ] Deleted 0 accessing users which which does not have any evidences associated 2021-07-09 11:22:05,112 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,112 [INFO ] Create Temp Table On Target (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,127 [INFO ] Created temporary working tables on target database needed for succeeding processes 2021-07-09 11:22:05,127 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,127 [INFO ] Populate UAL Manual Usage Devices (Execute on Source) (VersionFrom: 12.0) 2021-07-09 11:22:05,174 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,174 [INFO ] PopulateUALManualUsageDevicesForSharePointUsers (Execute on Source) (VersionFrom: 12.0) 2021-07-09 11:22:05,205 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,205 [INFO ] Transfer UAL Software Details (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,205 [INFO ] Transferred 0 records 2021-07-09 11:22:05,205 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,205 [INFO ] Transfer inferred UAL Software details (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,221 [INFO ] Transferred 0 records 2021-07-09 11:22:05,221 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,221 [INFO ] Transfer UAL Device Details (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,221 [INFO ] Transferred 0 records 2021-07-09 11:22:05,221 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,221 [INFO ] Transfer UAL User Details (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,221 [INFO ] Transferred 0 records 2021-07-09 11:22:05,221 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,221 [INFO ] Populate manual CAL detail for UAL (Execute on Source) (VersionFrom: 12.0) 2021-07-09 11:22:05,221 [INFO ] Added 0 new UAL client access details id value into temp table. 2021-07-09 11:22:05,221 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,221 [INFO ] Transfer UAL Client Access Details (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,221 [INFO ] Transferred 0 records 2021-07-09 11:22:05,221 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,221 [INFO ] Transfer UAL Client Access Occurrence Details (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,237 [INFO ] Transferred 0 records 2021-07-09 11:22:05,237 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,237 [INFO ] Process manual access evidence details and update temp table with new access evidence (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,237 [INFO ] Inserted 0 product into temp table. 2021-07-09 11:22:05,237 [INFO ] Updated 0 UALSoftwareDetailID with new referance id. 2021-07-09 11:22:05,237 [INFO ] Updated 0 ExternalUALSoftwareDetailID of temp table (ClientAccessDetail). 2021-07-09 11:22:05,237 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,237 [INFO ] Process Access Evidence Software Details (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,268 [INFO ] Removed 0 evidence from staging table. 2021-07-09 11:22:05,268 [INFO ] Added 0 evidence into staging table. 2021-07-09 11:22:05,268 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,268 [INFO ] Update access details evidence references (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,268 [INFO ] Updated 0 access evidence in temp table 2021-07-09 11:22:05,268 [INFO ] Updated 0 client access evidence in temp table 2021-07-09 11:22:05,268 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,268 [INFO ] Process Access Evidence User Details (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,299 [INFO ] Removed 0 accessing users from staging table. 2021-07-09 11:22:05,299 [INFO ] Added 0 accessing users into staging table. 2021-07-09 11:22:05,299 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,299 [INFO ] Process Access Evidence Device Details (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,346 [INFO ] Removed 0 accessing devices from staging table. 2021-07-09 11:22:05,346 [INFO ] Added 0 accessing devices into staging table. 2021-07-09 11:22:05,346 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,346 [INFO ] Process Access Evidence Occurrence Details - Index Temp Tables (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,346 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,346 [INFO ] Process Access Evidence Occurrence Details - Delete Evidence Access (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,346 [INFO ] Removed 0 accessed access evidence from staging table. 2021-07-09 11:22:05,346 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,346 [INFO ] Process Access Evidence Occurrence Details - Insert Evidence Access (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,362 [INFO ] Added 0 accessed access evidence into staging table. 2021-07-09 11:22:05,362 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,362 [INFO ] Process Access Evidence Occurrence Details - Delete Occurrences (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,393 [INFO ] Removed 0 accessed access occurrence from staging table. 2021-07-09 11:22:05,393 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,393 [INFO ] Process Access Evidence Occurrence Details - Insert Occurrences (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,409 [INFO ] Added 0 accessed access occurrence into staging table. 2021-07-09 11:22:05,409 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,409 [INFO ] Process Access Evidence Occurrence Details - Update Occurrences (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,424 [INFO ] Updated 0 access count of accessed access occurrences in staging table. 2021-07-09 11:22:05,424 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,424 [INFO ] Clean up target temp table (Execute on FNMP) (VersionFrom: 12.0) 2021-07-09 11:22:05,440 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,440 [INFO ] CreateInstallerEvidenceTempTablesOnSource (Execute on Source) 2021-07-09 11:22:05,440 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,440 [INFO ] CreateComplianceSettingTempTableOnTarget (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,455 [INFO ] Created temporary working tables on the target database needed for succeeding processes 2021-07-09 11:22:05,455 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,455 [INFO ] ImportIntoComplianceSettingTempTable (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,455 [INFO ] Inserted 219 tenant-specific and global compliance settings 2021-07-09 11:22:05,455 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,455 [INFO ] CreateInstallerEvidenceTempTablesOnTarget (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,471 [INFO ] Created temporary working tables on FNMP database needed for succeeding processes 2021-07-09 11:22:05,471 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,471 [INFO ] GetDistinctSoftwareInstallerEvidence (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:05,487 [INFO ] Found 0 Installer Evidence records in source database 2021-07-09 11:22:05,487 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,487 [INFO ] GetDistinctOracleEBSInstallerEvidence (Execute on Source) (VersionFrom: 8.4) 2021-07-09 11:22:05,487 [INFO ] Found 0 Installer Evidence records for Oracle EBS Modules in source database 2021-07-09 11:22:05,487 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,487 [INFO ] GetDistinctISOTagInstallerEvidence (Execute on Source) (VersionFrom: 8.6) 2021-07-09 11:22:05,518 [INFO ] Found 0 Software ID Tag (SWIDTag) Installer Evidence records in source database 2021-07-09 11:22:05,518 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,518 [INFO ] GetOtherDistinctInstallerEvidenceOnSource (Execute on Source) (VersionFrom: 9.2) 2021-07-09 11:22:05,518 [INFO ] Found 0 Installer Evidence records for AppV 4.6 in source database 2021-07-09 11:22:05,518 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,518 [INFO ] GetSoftwareInstallerEvidence (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:05,549 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,549 [INFO ] CreateComponentForChildInstance (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:05,549 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,549 [INFO ] GetOracleServiceComponentInstallerEvidence (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:05,565 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,565 [INFO ] GetVMwareServiceComponentInstallerEvidence (Execute on Source) (VersionFrom: 10.2) 2021-07-09 11:22:05,565 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,565 [INFO ] GetOracleEBSInstallerEvidence (Execute on Source) (VersionFrom: 8.4) 2021-07-09 11:22:05,565 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,565 [INFO ] GetDB2InstanceInstallerEvidence (Execute on Source) (VersionFrom: 16.0) 2021-07-09 11:22:05,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,596 [INFO ] GetISOTagInstallerEvidence (Execute on Source) (VersionFrom: 8.6) 2021-07-09 11:22:05,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,596 [INFO ] GetAppVInstallerEvidence (Execute on Source) (VersionFrom: 9.2) 2021-07-09 11:22:05,612 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,612 [INFO ] TransferInstallerEvidence (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,627 [INFO ] Transferred 5 records 2021-07-09 11:22:05,627 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,627 [INFO ] MapAppVInstallerEvidence (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:05,627 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,627 [INFO ] TransferInstallerEvidenceRepackageMapping (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.6) 2021-07-09 11:22:05,643 [INFO ] Transferred 3 records 2021-07-09 11:22:05,643 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,643 [INFO ] UpdateImportedInstallerEvidenceRepackageMappingTable (Execute on FNMP) (VersionFrom: 8.6) 2021-07-09 11:22:05,659 [INFO ] Removed 0 Installer Evidence mapping records in ImportedInstallerEvidenceRepackageMapping staging table for repackaged applications 2021-07-09 11:22:05,659 [INFO ] Added 0 Installer Evidence mapping records into ImportedInstallerEvidenceRepackageMapping staging table for repackaged applications 2021-07-09 11:22:05,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,659 [INFO ] GetSoftwareInstalledInstallerEvidence (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:05,799 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,799 [INFO ] GetOracleServiceComponentInstalledInstallerEvidence (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:05,815 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,815 [INFO ] GetVMwareServiceComponentInstalledInstallerEvidence (Execute on Source) (VersionFrom: 10.2) 2021-07-09 11:22:05,815 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,815 [INFO ] GetOracleEBSInstalledInstallerEvidence (Execute on Source) (VersionFrom: 8.4) 2021-07-09 11:22:05,815 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,830 [INFO ] GetDB2ComponentInstalledInstallerEvidence (Execute on Source) (VersionFrom: 16.0) 2021-07-09 11:22:05,830 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,830 [INFO ] GetISOTagInstalledInstallerEvidence (Execute on Source) (VersionFrom: 8.6) 2021-07-09 11:22:05,830 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,830 [INFO ] GetAppVInstalledInstallerEvidence (Execute on Source) (VersionFrom: 9.2) 2021-07-09 11:22:05,846 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,846 [INFO ] TransferInstalledInstallerEvidence (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,862 [INFO ] Transferred 57 records 2021-07-09 11:22:05,862 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,862 [INFO ] UpdateTheEvidenceFieldInImportedInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,877 [INFO ] Updated the Type values of 4 Installer Evidence records with the most commonly used type 2021-07-09 11:22:05,877 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,877 [INFO ] CreateIndexesOnTempInstallerEvidenceTables (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:05,893 [INFO ] Created table indexes to improve performance 2021-07-09 11:22:05,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,893 [INFO ] ImportIntoTempInstance (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 13.1) 2021-07-09 11:22:05,893 [INFO ] Transferred 0 records 2021-07-09 11:22:05,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,893 [INFO ] ImportIntoTempInstance (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 16.0) 2021-07-09 11:22:05,893 [INFO ] Transferred 0 records 2021-07-09 11:22:05,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,893 [INFO ] ImportIntoTempDB2Instance (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 16.0) 2021-07-09 11:22:05,893 [INFO ] Transferred 0 records 2021-07-09 11:22:05,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,893 [INFO ] ImportInstanceUsers (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.4) 2021-07-09 11:22:05,893 [INFO ] Transferred 0 records 2021-07-09 11:22:05,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,893 [INFO ] PopulateUserMappings (Execute on FNMP) 2021-07-09 11:22:05,893 [INFO ] Updated 0 external ids in #InstanceUser table with corresponging mapping IDs 2021-07-09 11:22:05,893 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,893 [INFO ] ImportInstallerEvidenceAttributeNames (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.4) 2021-07-09 11:22:05,909 [INFO ] Ensured LMS_OVERVIEW_CPU_MODE attribute is included 2021-07-09 11:22:05,909 [INFO ] Ensured LMS_OVERVIEW_EDITION attribute is included 2021-07-09 11:22:05,909 [INFO ] Ensured LMS_OVERVIEW_USER_COUNT attribute is included 2021-07-09 11:22:05,909 [INFO ] Ensured LMS_OVERVIEW_VERSION attribute is included 2021-07-09 11:22:05,909 [INFO ] Ensured OracleEBSApplicationID attribute is included 2021-07-09 11:22:05,955 [INFO ] Transferred 69 records 2021-07-09 11:22:05,955 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:05,955 [INFO ] ImportInstallerEvidenceAttributeValues (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.4) 2021-07-09 11:22:06,002 [INFO ] Transferred 568 records 2021-07-09 11:22:06,002 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,002 [INFO ] ImportInstallerEvidenceAttributeValues (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 10.0) 2021-07-09 11:22:06,362 [INFO ] Transferred 0 records 2021-07-09 11:22:06,362 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,362 [INFO ] DeleteFromTempImportedInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,377 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,377 [INFO ] InsertIntoImportedInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,409 [INFO ] Added 1 new Installer Evidence records into ImportedInstallerEvidence staging table that exist in source database 2021-07-09 11:22:06,409 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,409 [INFO ] UpdateTempImportedInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,424 [INFO ] Mapped 5 new Installer Evidence IDs back to temporary working table 2021-07-09 11:22:06,424 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,424 [INFO ] DeleteFromImportedInstalledInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,440 [INFO ] Removed 0 Installer Evidence installation records in ImportedInstalledInstallerEvidence staging table that no longer exist in source database 2021-07-09 11:22:06,440 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,440 [INFO ] InsertIntoImportedInstalledInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,455 [INFO ] Added 0 new Installer Evidence installation records into ImportedInstalledInstallerEvidence staging table that exist in source database 2021-07-09 11:22:06,455 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,455 [INFO ] DeleteFromImportedInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,471 [INFO ] Removed 1 Installer Evidence records in ImportedInstallerEvidence staging table that are not shown as installed 2021-07-09 11:22:06,471 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,471 [INFO ] DeleteFromImportedInstances (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,487 [INFO ] Removed 0 Instance records in ImportedInstance staging table that no longer exist in source database 2021-07-09 11:22:06,487 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,487 [INFO ] UpdateImportedInstances (Execute on FNMP) (VersionFrom: 13.1) 2021-07-09 11:22:06,487 [INFO ] Updated 0 Instance records in ImportedInstance staging table 2021-07-09 11:22:06,487 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,487 [INFO ] InsertIntoImportedInstances (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,487 [INFO ] Added 0 Instance records into ImportedInstance staging table that exist in source database 2021-07-09 11:22:06,487 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,487 [INFO ] UpdateInstanceTypeForDB2 (Execute on FNMP) (VersionFrom: 16.0) 2021-07-09 11:22:06,502 [INFO ] Updated 0DB2 Instance type for ImportedInstance staging table 2021-07-09 11:22:06,502 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,502 [INFO ] DeleteFromImportedInstanceUsers (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,502 [INFO ] Removed 0 Instance User records in ImportedInstanceUser staging table that no longer exist in source database 2021-07-09 11:22:06,502 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,502 [INFO ] UpdateImportedInstanceUsers (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,518 [INFO ] Updated 0 Instance User records in ImportedInstanceUser staging table 2021-07-09 11:22:06,518 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,518 [INFO ] InsertIntoImportedInstanceUsers (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,518 [INFO ] Added 0 Instance User records into ImportedInstanceUser staging table that exist in source database 2021-07-09 11:22:06,518 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,518 [INFO ] DeleteDerivedAttributesInTarget (Execute on FNMP) (VersionFrom: 8.4) 2021-07-09 11:22:06,518 [INFO ] Removed derived attributes from ImportedEvidenceAttribute so that IDs for these attributes will always be updated. 2021-07-09 11:22:06,518 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,518 [INFO ] DeleteFromImportedAttributes (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,534 [INFO ] Removed 0 Evidence Attributes in ImportedEvidenceAttribute staging table that no longer exist in source database 2021-07-09 11:22:06,534 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,534 [INFO ] InsertIntoImportedAttributes (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,534 [INFO ] Added 5 new Evidence Attributes into ImportedEvidenceAttribute staging table that exist in source database 2021-07-09 11:22:06,534 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,534 [INFO ] DeleteFromImportedInstallerAttributes (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,580 [INFO ] Removed 0 installed Installer Evidence attribute values in ImportedInstalledInstallerEvidenceAttribute staging table 2021-07-09 11:22:06,580 [INFO ] Updated 0 installed Installer Evidence attribute values in ImportedInstalledInstallerEvidenceAttribute staging table 2021-07-09 11:22:06,580 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,580 [INFO ] InsertIntoImportedInstallerAttributes (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,596 [INFO ] Added 0 installed Installer Evidence attribute values into ImportedInstalledInstallerEvidenceAttribute staging table 2021-07-09 11:22:06,596 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,596 [INFO ] CleanupInstallerTemporaryTablesOnSource (Execute on Source) (VersionFrom: 8.0) 2021-07-09 11:22:06,612 [INFO ] Removed temporary working tables 2021-07-09 11:22:06,612 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,612 [INFO ] CleanupInstallerTemporaryTablesOnTarget (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,612 [INFO ] Removed temporary working tables 2021-07-09 11:22:06,612 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,612 [INFO ] GenerateEBSInstallerEvidence (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:06,690 [INFO ] Found 0 instances of an Oracle EBS server 2021-07-09 11:22:06,690 [INFO ] Removed 0 generated installed installer evidence Oracle EBS server records 2021-07-09 11:22:06,690 [INFO ] Added 0 generated installed installer evidence Oracle EBS server records 2021-07-09 11:22:06,690 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,690 [INFO ] CaptureVMwarevCenterToESXHostsRelationships (Execute on FNMP) (VersionFrom: 10.2) 2021-07-09 11:22:06,737 [INFO ] Captured 55 VM hosts managed by management software relationships 2021-07-09 11:22:06,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,737 [INFO ] CreateComputerScriptResultTempTableOnTarget (Execute on FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:06,737 [INFO ] Created temporary working tables on the target database needed for succeeding processes 2021-07-09 11:22:06,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,737 [INFO ] TransferComputerScriptResult (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:06,737 [INFO ] Transferred 0 records 2021-07-09 11:22:06,737 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,737 [INFO ] UpdateImportedComputerScriptResult (Execute on FNMP) (VersionFrom: 12.1) 2021-07-09 11:22:06,752 [INFO ] Removed 0 records in ImportedComputerScriptResult staging table 2021-07-09 11:22:06,752 [INFO ] Updated 0 records in ImportedComputerScriptResult staging table 2021-07-09 11:22:06,752 [INFO ] Added 0 records into ImportedComputerScriptResult staging table 2021-07-09 11:22:06,752 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,752 [INFO ] WMIEvidenceClear (Execute on FNMP) 2021-07-09 11:22:06,784 [INFO ] Created temporary working tables in FNMP database needed for succeeding processes 2021-07-09 11:22:06,784 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,784 [INFO ] CreateApplicationWMITempTables (Execute on Source) 2021-07-09 11:22:06,784 [INFO ] Created temporary working tables in source database needed for succeeding processes 2021-07-09 11:22:06,784 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,784 [INFO ] InsertIntoWMITempApplicationFile (Transfer from FNMP to source 'FlexNet Manager Suite') 2021-07-09 11:22:06,799 [INFO ] Transferred 1343 records 2021-07-09 11:22:06,799 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,799 [INFO ] Create local ManageSoft WMIEvidenceID Table (Execute on Source) 2021-07-09 11:22:06,862 [INFO ] Found 4 unique WMI Evidence records in source database 2021-07-09 11:22:06,862 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:06,862 [INFO ] Include additional WMI Evidence (Execute on Source) 2021-07-09 11:22:07,002 [INFO ] Found additional 296 WMI Evidence records in source database 2021-07-09 11:22:07,002 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,002 [INFO ] Create local ManageSoft WMIEvidenceID Table for Adobe (Execute on Source) (VersionFrom: 8.6) 2021-07-09 11:22:07,049 [INFO ] Found 0 unique WMI Evidence records in source database 2021-07-09 11:22:07,049 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,049 [INFO ] Create local ManageSoft WMIEvidenceID Table for Adobe Acrobat 2017 (Execute on Source) (VersionFrom: 8.6) 2021-07-09 11:22:07,096 [INFO ] Found 8 unique WMI Evidence records in source database 2021-07-09 11:22:07,096 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,096 [INFO ] WMIEvidencePrimaryRead (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.6) 2021-07-09 11:22:07,112 [INFO ] Transferred 304 records 2021-07-09 11:22:07,112 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,112 [INFO ] Target Setup: Clear the ImportedInstalledWMIEvidence table (Execute on FNMP) 2021-07-09 11:22:07,127 [INFO ] Added 304 new WMI Evidence records into ImportedWMIEvidence staging table that exist in source database 2021-07-09 11:22:07,127 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,127 [INFO ] Installed WMIEvidence Primary read (Transfer data from source 'FlexNet Manager Suite' to FNMP) 2021-07-09 11:22:07,613 [INFO ] Transferred 3101 records 2021-07-09 11:22:07,613 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,613 [INFO ] ImportInstalledWMIEvidenceRead (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.6) 2021-07-09 11:22:07,628 [INFO ] Transferred 8 records 2021-07-09 11:22:07,628 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,628 [INFO ] Reading data for 'Evidence' successfully processed in 3 seconds. 2021-07-09 11:22:07,628 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_Evidence_ALL 2021-07-09 11:22:07,628 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:07,628 [INFO ] Reading 'Usage' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:07,628 [INFO ] CheckThatFileEvidenceHasBeenRun (Execute on Source) 2021-07-09 11:22:07,628 [INFO ] Checked for existence of required temporary working tables on the source database 2021-07-09 11:22:07,628 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,628 [INFO ] CreateOldestAppUsagePeriodTemporaryTable (Execute on Source) 2021-07-09 11:22:07,628 [INFO ] Created temporary working tables on source database needed for succeeding processes 2021-07-09 11:22:07,628 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,628 [INFO ] SendOldestUsagePeriodToSource (Transfer from FNMP to source 'FlexNet Manager Suite') 2021-07-09 11:22:07,659 [INFO ] Transferred 1 records 2021-07-09 11:22:07,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,659 [INFO ] Set default usage period for disconnected import (Execute on Source) 2021-07-09 11:22:07,659 [INFO ] This reader only executes when the connection is in disconnected mode. 2021-07-09 11:22:07,659 [INFO ] Completed in 0 seconds. 2021-07-09 11:22:07,659 [INFO ] CreateTemporaryFileEvidenceUsageTables (Execute on FNMP) 2021-07-09 11:22:07,659 [INFO ] Created temporary working tables on FNMP database needed for succeeding processes 2021-07-09 11:22:07,659 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,659 [INFO ] ImportIntoTempImportedFileEvidenceUsage (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.4) 2021-07-09 11:22:07,706 [WARN ] Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'IX_#CleanSoftwareFileUsage' has maximum length of 8072 bytes. For some combination of large values, the insert/update operation will fail. 2021-07-09 11:22:07,706 [INFO ] Transferred 0 records 2021-07-09 11:22:07,706 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,706 [INFO ] ImportIntoTempImportedInstallerEvidenceUsage (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:07,722 [INFO ] Transferred 0 records 2021-07-09 11:22:07,722 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,722 [INFO ] CleanExistingImportedInstalledFileEvidenceUsage (Execute on FNMP) 2021-07-09 11:22:07,738 [INFO ] Removed 0 installed file evidence Usage records in ImportedInstalledFileEvidenceUsage staging table that no longer exist from source database 2021-07-09 11:22:07,738 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,738 [INFO ] CleanExistingImportedInstalledInstallerEvidenceUsage (Execute on FNMP) 2021-07-09 11:22:07,738 [INFO ] Removed 0 installed installer evidence Usage records in ImportedInstalledInstallerEvidenceUsage staging table that no longer exist from source database 2021-07-09 11:22:07,738 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,738 [INFO ] ImportIntoImportedInstalledFileEvidenceUsage (Execute on FNMP) 2021-07-09 11:22:07,738 [INFO ] Added 0 installed file evidence usage records into ImportedInstalledFileEvidenceUsage staging table that exist from source database 2021-07-09 11:22:07,738 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,738 [INFO ] ImportIntoImportedInstalledInstallerEvidenceUsage (Execute on FNMP) (VersionFrom: 8.0) 2021-07-09 11:22:07,753 [INFO ] Added 0 installed installer evidence usage records into ImportedInstalledInstallerEvidenceUsage staging table that exist from source database 2021-07-09 11:22:07,753 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,753 [INFO ] GetApplicationInstallationUsage (Execute on Source) (VersionFrom: 8.6) 2021-07-09 11:22:07,878 [INFO ] Retrieved 0 application installation usage records 2021-07-09 11:22:07,878 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,878 [INFO ] TransferApplicationInstallationUsage (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 8.6) 2021-07-09 11:22:07,909 [INFO ] Transferred 0 records 2021-07-09 11:22:07,925 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,925 [INFO ] PopulateApplicationInstallationUsage (Execute on FNMP) (VersionFrom: 8.6) 2021-07-09 11:22:07,941 [INFO ] Added 0 application installation usage records 2021-07-09 11:22:07,941 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,941 [INFO ] ImportAppVUsageData (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:07,941 [INFO ] Transferred 0 records 2021-07-09 11:22:07,941 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,941 [INFO ] GetAppVInstallerData (Execute on FNMP) (VersionFrom: 9.2) 2021-07-09 11:22:07,988 [INFO ] Updated 0 last used date records for AppV installer evidence usage. 2021-07-09 11:22:07,988 [INFO ] Added 0 installed installer evidence usage related to App-V 2021-07-09 11:22:07,988 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:07,988 [INFO ] CleanupUsageTemporaryTablesOnSource (Execute on Source) 2021-07-09 11:22:07,988 [INFO ] Removed temporary working tables on source database 2021-07-09 11:22:08,003 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:08,003 [INFO ] CleanupUsageTemporaryTablesOnTarget (Execute on FNMP) 2021-07-09 11:22:08,003 [INFO ] Removed temporary working tables on FNMP database 2021-07-09 11:22:08,003 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:08,003 [INFO ] Reading data for 'Usage' successfully processed in 0 seconds. 2021-07-09 11:22:08,019 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_Usage_ALL 2021-07-09 11:22:08,019 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,019 [INFO ] Reading 'LicenseCreateUpdate' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:08,019 [INFO ] Reading data for 'LicenseCreateUpdate' successfully processed in 0 seconds. 2021-07-09 11:22:08,019 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_LicenseCreateUpdate_ALL 2021-07-09 11:22:08,019 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,019 [INFO ] Reading 'Complete' data from 'FlexNet Manager Suite' (ver 16.0) data source 2021-07-09 11:22:08,019 [INFO ] MarkSuccessfulImport (Execute on FNMP) 2021-07-09 11:22:08,019 [INFO ] Updated successful inventory date on 0 imported computer records 2021-07-09 11:22:08,019 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:08,019 [INFO ] UpdatePVUReconcileEnabledState (Execute on FNMP) 2021-07-09 11:22:08,019 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:08,019 [INFO ] DeleteFromImportedFileEvidence (Execute on FNMP) 2021-07-09 11:22:08,066 [INFO ] Identified 0 ImportedFileEvidence records to be deleted 2021-07-09 11:22:08,066 [INFO ] Removed 0 ImportedFileEvidence records in ImportedFileEvidence staging table 2021-07-09 11:22:08,066 [INFO ] Successfully processed in 0 seconds. 2021-07-09 11:22:08,066 [INFO ] Reading data for 'Complete' successfully processed in 0 seconds. 2021-07-09 11:22:08,066 [INFO ] Released application lock Reader_41f067c9-547c-4799-9cb3-851ec6a69152_Complete_ALL 2021-07-09 11:22:08,081 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,113 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,191 [DEBUG] Existing task execution id: 37824 for sessionID: 8100df3f-f574-4424-9101-bed4b0fff6b4, EventTypeId: 183 2021-07-09 11:22:08,300 [DEBUG] Update the step with execution ID: 37824, EventTypeID: 183, StepID: 3, EventID: 860782, SessionUID: 8100df3f-f574-4424-9101-bed4b0fff6b4 2021-07-09 11:22:08,394 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config 2021-07-09 11:22:08,394 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,644 [INFO ] Importing from 'FNMPDataWarehouse' [type: FNMPDataWarehouse] 2021-07-09 11:22:08,644 [INFO ] No readers defined for data source with type 'FNMPDataWarehouse', name 'FNMPDataWarehouse'. 2021-07-09 11:22:08,644 [INFO ] Skipping remote connection 'FlexeraSCCMconnection_5c0db015-cc11-4d78-be6e-affce50252e3', because no successful matching package could be found at C:\ProgramData\Flexera Software\Beacon\IntermediateData. 2021-07-09 11:22:08,644 [INFO ] Skipping remote connection 'FlexeraSCCMconnection_33b89f7b-b8b8-4f21-9b33-9214fb889276', because no successful matching package could be found at C:\ProgramData\Flexera Software\Beacon\IntermediateData. 2021-07-09 11:22:08,659 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,659 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config 2021-07-09 11:22:08,659 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,675 [DEBUG] Existing task execution id: 0 for sessionID: f40d2b53-5595-4ed4-a91f-20733b3c5aaa, EventTypeId: 185 2021-07-09 11:22:08,691 [DEBUG] New task execution id: 37825 for sessionID: f40d2b53-5595-4ed4-a91f-20733b3c5aaa, EventTypeId: 185 2021-07-09 11:22:08,769 [DEBUG] Update the step with execution ID: 37825, EventTypeID: 186, StepID: 30, EventID: 860784, SessionUID: f40d2b53-5595-4ed4-a91f-20733b3c5aaa 2021-07-09 11:22:08,894 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,894 [INFO ] Writing data for 'ActiveDirectory' 2021-07-09 11:22:08,894 [INFO ] ActiveDirectoryDomains 2021-07-09 11:22:08,909 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:08,972 [INFO ] Attempting to retrieve a list of domains from Active Directory 2021-07-09 11:22:09,284 [INFO ] Found 1 domains from Active Directory 2021-07-09 11:22:09,284 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:09,300 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,300 [INFO ] CreateTempTables 2021-07-09 11:22:09,316 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,316 [INFO ] GetLatestActiveDirectoryDomainData 2021-07-09 11:22:09,316 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,316 [INFO ] ImportActiveDirectoryDomains 2021-07-09 11:22:09,347 [INFO ] Deleted 0 Active Directory Domains 2021-07-09 11:22:09,347 [INFO ] Updated 2 Active Directory Domains 2021-07-09 11:22:09,347 [INFO ] Added 0 Active Directory Domains 2021-07-09 11:22:09,347 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,347 [INFO ] MapIncomingDomains 2021-07-09 11:22:09,347 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,347 [INFO ] ImportActiveDirectoryGroups 2021-07-09 11:22:09,644 [INFO ] Deleted 0 Active Directory Groups 2021-07-09 11:22:09,644 [INFO ] Updated 9290 Active Directory Groups 2021-07-09 11:22:09,644 [INFO ] Added 0 Active Directory Groups 2021-07-09 11:22:09,644 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,644 [INFO ] ImportActiveDirectoryUsers 2021-07-09 11:22:09,831 [INFO ] Deleted 0 Active Directory Users 2021-07-09 11:22:09,831 [INFO ] Updated 5590 Active Directory Users 2021-07-09 11:22:09,831 [INFO ] Added 0 Active Directory Users 2021-07-09 11:22:09,831 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,831 [INFO ] ImportActiveDirectoryComputers 2021-07-09 11:22:09,972 [INFO ] Deleted 0 Active Directory Computers 2021-07-09 11:22:09,972 [INFO ] Updated 4949 Active Directory Computers 2021-07-09 11:22:09,972 [INFO ] Added 0 Active Directory Computers 2021-07-09 11:22:09,972 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:09,972 [INFO ] ImportActiveDirectoryMembers 2021-07-09 11:22:10,816 [INFO ] Found 117300 Active Directory members 2021-07-09 11:22:10,816 [INFO ] Found 0 external Active Directory member groups 2021-07-09 11:22:10,816 [INFO ] Found 0 external Active Directory member users 2021-07-09 11:22:10,816 [INFO ] Found 0 external Active Directory member computers 2021-07-09 11:22:10,816 [INFO ] Deleted 0 Active Directory Members 2021-07-09 11:22:10,816 [INFO ] Added 0 Active Directory Members 2021-07-09 11:22:10,816 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,816 [INFO ] CacheBeaconSubnetMapping 2021-07-09 11:22:10,816 [INFO ] Cached 37 subnet to beacon mapping records 2021-07-09 11:22:10,816 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,816 [INFO ] ImportSites 2021-07-09 11:22:10,847 [INFO ] Added 0 Active Directory sites 2021-07-09 11:22:10,847 [INFO ] Deleted 0 Active Directory sites 2021-07-09 11:22:10,847 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,847 [INFO ] UpdateBeaconSubnetMapping 2021-07-09 11:22:10,862 [INFO ] Added 0 beacon subnet mapping records from existing mappings 2021-07-09 11:22:10,862 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,862 [INFO ] ImportSubnets 2021-07-09 11:22:10,894 [INFO ] Added 0 Active Directory subnets 2021-07-09 11:22:10,894 [INFO ] Deleted 0 Active Directory subnets 2021-07-09 11:22:10,894 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,894 [INFO ] CleanupTempTables 2021-07-09 11:22:10,909 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,909 [INFO ] Writing data for 'ActiveDirectory' successfully processed in 2 seconds. 2021-07-09 11:22:10,909 [INFO ] Released application lock Writer_Source_ActiveDirectory_ALL 2021-07-09 11:22:10,909 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:10,909 [INFO ] Writing data for 'Computer' 2021-07-09 11:22:10,909 [INFO ] GetAdditionalApplicationLocks 2021-07-09 11:22:10,909 [INFO ] Created additional application lock Writer_Source_AdditionalApplicationLock_ALL 2021-07-09 11:22:10,909 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,909 [INFO ] Setup ActiveSync Tables 2021-07-09 11:22:10,925 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,925 [INFO ] Collate ActiveSync Devices 2021-07-09 11:22:10,925 [INFO ] Identified 0 unique ActiveSync devices 2021-07-09 11:22:10,925 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,925 [INFO ] Map ActiveSync Device Details 2021-07-09 11:22:10,972 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:10,972 [INFO ] Create Device Computer Records 2021-07-09 11:22:11,019 [INFO ] Updated 0 devices from ActiveSync information 2021-07-09 11:22:11,019 [INFO ] Added 0 devices from ActiveSync information 2021-07-09 11:22:11,019 [INFO ] Removed 0 devices that no longer exist in ActiveSync source connections 2021-07-09 11:22:11,019 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,019 [INFO ] Cleanup Active Sync Tables 2021-07-09 11:22:11,019 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,019 [INFO ] WriteDomains 2021-07-09 11:22:11,128 [INFO ] Added 0 records into ImportedDomain from ImportedUser 2021-07-09 11:22:11,128 [INFO ] Added 0 records into ImportedDomain from ImportedComputer 2021-07-09 11:22:11,128 [INFO ] Updated 0 domains that previously had no qualified names 2021-07-09 11:22:11,128 [INFO ] Updated 3 domains with flat names 2021-07-09 11:22:11,128 [INFO ] Added 0 new domains with flat names 2021-07-09 11:22:11,128 [INFO ] Added 0 new domains without flat names. 2021-07-09 11:22:11,128 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,128 [INFO ] Merge and remove duplicate domains 2021-07-09 11:22:11,175 [INFO ] Found 0 duplicate domains that can be merged. 2021-07-09 11:22:11,175 [INFO ] Merged 0 computers from the obsolete duplicate domain. 2021-07-09 11:22:11,175 [INFO ] Merged 0 users from the obsolete duplicate domain. 2021-07-09 11:22:11,175 [INFO ] Merged 0 imported domains away from a duplicate compliance domain. 2021-07-09 11:22:11,175 [INFO ] Removed 0 user(s) from the old domain that already exist in the new domain. 2021-07-09 11:22:11,175 [INFO ] Removed 0 duplicate domains. 2021-07-09 11:22:11,175 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,175 [INFO ] Create SAP Users 2021-07-09 11:22:11,191 [INFO ] Found 0 new SAP users from data sources 2021-07-09 11:22:11,191 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,191 [INFO ] Insert custom Cloud Service Provider 2021-07-09 11:22:11,191 [INFO ] Added 0 new cloud service provider. 2021-07-09 11:22:11,191 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,191 [INFO ] Update ImportedUser from ImportedUser for records that are flagged to map using email 2021-07-09 11:22:11,237 [INFO ] Updated 0 users whose email matched to the email of an existing user from another data source 2021-07-09 11:22:11,237 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,237 [INFO ] Update ImportedUser from ComplianceUser for records that are flagged to map using email 2021-07-09 11:22:11,300 [INFO ] Updated 0 users whose email matched to the email of an existing user 2021-07-09 11:22:11,300 [INFO ] Updated 0 users whose email matched to the alternate email of an existing user 2021-07-09 11:22:11,300 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:11,300 [INFO ] UsersWriter 2021-07-09 11:22:12,597 [INFO ] Added 0 ImportedUsers in to temp table for processing 2021-07-09 11:22:12,597 [INFO ] Matched 0 incoming users with existing domains 2021-07-09 11:22:12,597 [INFO ] Found 1 users who are block listed 2021-07-09 11:22:12,612 [INFO ] Matched 24 existing users with incoming users by sam account name and domain 2021-07-09 11:22:12,612 [INFO ] Added 0 new users that have no matching sam account name and domain 2021-07-09 11:22:12,612 [INFO ] Matched 0 users by email address 2021-07-09 11:22:12,612 [INFO ] Added 0 new users based on their email address 2021-07-09 11:22:12,612 [INFO ] Added 0 new users based on their EmployeeNumber, UserName, FirstName, and LastName 2021-07-09 11:22:12,612 [INFO ] Added a total of 0 new users from the source database connections 2021-07-09 11:22:12,612 [INFO ] Successfully processed in 1 second 2021-07-09 11:22:12,612 [INFO ] Generate users from email address 2021-07-09 11:22:12,675 [INFO ] Added 0 new users that were generated from their email address 2021-07-09 11:22:12,675 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:12,675 [INFO ] Update user data 2021-07-09 11:22:13,206 [INFO ] Updated 0 users from non-primary connections 2021-07-09 11:22:13,206 [INFO ] Updated 0 Users that have changed in the source database connections. 2021-07-09 11:22:13,206 [INFO ] Marked 0 block listed users as excluded 2021-07-09 11:22:13,206 [INFO ] Marked 0 non block listed users as included 2021-07-09 11:22:13,206 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:13,206 [INFO ] LicenseUsersWriter 2021-07-09 11:22:13,237 [INFO ] Found 0 License Users by Connection and External ID 2021-07-09 11:22:13,237 [INFO ] Found 0 License Users by name 2021-07-09 11:22:13,237 [INFO ] Added 0 License Users 2021-07-09 11:22:13,237 [INFO ] Updated 0 License Users from non-primary connections 2021-07-09 11:22:13,237 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:13,237 [INFO ] ComplianceLicenseUser Writer 2021-07-09 11:22:13,269 [INFO ] Added 0 new links between license users and users 2021-07-09 11:22:13,269 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:13,269 [INFO ] Update ImportedUser from temp table 2021-07-09 11:22:13,487 [INFO ] Updated 14377 ImportedUsers with data from temp table 2021-07-09 11:22:13,487 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:13,487 [INFO ] Create SAP Computers 2021-07-09 11:22:13,487 [INFO ] Added 0 SAP devices in to ImportedComputer 2021-07-09 11:22:13,487 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:13,487 [INFO ] Prepare imported computers for matching 2021-07-09 11:22:13,644 [INFO ] Reset 9282 imported computer records in preparation for matching 2021-07-09 11:22:13,644 [INFO ] Found 0 imported computer records with duplicate ILMT Agent IDs in a single inventory connection 2021-07-09 11:22:13,644 [INFO ] Removed 0 imported computer records with duplicate ILMT Agent IDs in a single inventory connection 2021-07-09 11:22:13,644 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:13,644 [INFO ] Perform computer matching 2021-07-09 11:22:13,644 [INFO ] Running computer matching engine. 2021-07-09 11:22:13,644 [INFO ] Initializing computer matching. 2021-07-09 11:22:13,706 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:14,128 [INFO ] Initialized computer matching. 2021-07-09 11:22:14,128 [INFO ] Matching complete imported objects. 2021-07-09 11:22:14,144 [INFO ] Executing matcher 'Match VMware ESX Servers by computer name and domain ID' against complete imported objects. 2021-07-09 11:22:14,190 [INFO ] Populated hashes for matcher 'Match VMware ESX Servers by computer name and domain ID' against imported objects. 2021-07-09 11:22:14,269 [INFO ] Executing matcher 'Match VMware ESX Servers by computer name and domain ID' matched 56 complete imported objects. 2021-07-09 11:22:14,269 [INFO ] Executing matcher 'Match by manufacturer, model, firmware serial number and host ID for physical computer' against complete imported objects. 2021-07-09 11:22:14,300 [INFO ] Populated hashes for matcher 'Match by manufacturer, model, firmware serial number and host ID for physical computer' against imported objects. 2021-07-09 11:22:14,362 [INFO ] Executing matcher 'Match by manufacturer, model, firmware serial number and host ID for physical computer' matched 0 complete imported objects. 2021-07-09 11:22:14,362 [INFO ] Executing matcher 'Match by manufacturer, model and firmware serial number for physical computer with no host ID' against complete imported objects. 2021-07-09 11:22:14,394 [INFO ] Populated hashes for matcher 'Match by manufacturer, model and firmware serial number for physical computer with no host ID' against imported objects. 2021-07-09 11:22:14,472 [INFO ] Executing matcher 'Match by manufacturer, model and firmware serial number for physical computer with no host ID' matched 0 complete imported objects. 2021-07-09 11:22:14,472 [INFO ] Executing matcher 'Match by manufacturer, host type, firmware serial number and host ID for physical computer' against complete imported objects. 2021-07-09 11:22:14,503 [INFO ] Populated hashes for matcher 'Match by manufacturer, host type, firmware serial number and host ID for physical computer' against imported objects. 2021-07-09 11:22:14,550 [INFO ] Executing matcher 'Match by manufacturer, host type, firmware serial number and host ID for physical computer' matched 0 complete imported objects. 2021-07-09 11:22:14,565 [INFO ] Executing matcher 'Match by manufacturer, host type and firmware serial number for physical computer with no host ID' against complete imported objects. 2021-07-09 11:22:14,581 [INFO ] Populated hashes for matcher 'Match by manufacturer, host type and firmware serial number for physical computer with no host ID' against imported objects. 2021-07-09 11:22:14,659 [INFO ] Executing matcher 'Match by manufacturer, host type and firmware serial number for physical computer with no host ID' matched 0 complete imported objects. 2021-07-09 11:22:14,659 [INFO ] Executing matcher 'Match by machine ID for physical computer' against complete imported objects. 2021-07-09 11:22:14,659 [INFO ] Populated hashes for matcher 'Match by machine ID for physical computer' against imported objects. 2021-07-09 11:22:14,706 [INFO ] Executing matcher 'Match by machine ID for physical computer' matched 0 complete imported objects. 2021-07-09 11:22:14,706 [INFO ] Executing matcher 'Match by manufacturer, host ID and computer name for physical computer' against complete imported objects. 2021-07-09 11:22:14,722 [INFO ] Populated hashes for matcher 'Match by manufacturer, host ID and computer name for physical computer' against imported objects. 2021-07-09 11:22:14,784 [INFO ] Executing matcher 'Match by manufacturer, host ID and computer name for physical computer' matched 0 complete imported objects. 2021-07-09 11:22:14,784 [INFO ] Executing matcher 'Match by partition ID for LPAR, vPar and zone' against complete imported objects. 2021-07-09 11:22:14,800 [INFO ] Populated hashes for matcher 'Match by partition ID for LPAR, vPar and zone' against imported objects. 2021-07-09 11:22:14,831 [INFO ] Executing matcher 'Match by partition ID for LPAR, vPar and zone' matched 0 complete imported objects. 2021-07-09 11:22:14,831 [INFO ] Executing matcher 'Match by firmware serial number and partition number for LPAR' against complete imported objects. 2021-07-09 11:22:14,862 [INFO ] Populated hashes for matcher 'Match by firmware serial number and partition number for LPAR' against imported objects. 2021-07-09 11:22:14,878 [INFO ] Executing matcher 'Match by firmware serial number and partition number for LPAR' matched 0 complete imported objects. 2021-07-09 11:22:14,878 [INFO ] Executing matcher 'Match by machine ID and partition number for LPAR' against complete imported objects. 2021-07-09 11:22:14,909 [INFO ] Populated hashes for matcher 'Match by machine ID and partition number for LPAR' against imported objects. 2021-07-09 11:22:14,940 [INFO ] Executing matcher 'Match by machine ID and partition number for LPAR' matched 0 complete imported objects. 2021-07-09 11:22:14,940 [INFO ] Executing matcher 'Match by machine ID and partition name for vPar, nPar and LPAR' against complete imported objects. 2021-07-09 11:22:14,956 [INFO ] Populated hashes for matcher 'Match by machine ID and partition name for vPar, nPar and LPAR' against imported objects. 2021-07-09 11:22:14,987 [INFO ] Executing matcher 'Match by machine ID and partition name for vPar, nPar and LPAR' matched 0 complete imported objects. 2021-07-09 11:22:14,987 [INFO ] Executing matcher 'Match by firmware serial number and partition name for vPar, nPar and LPAR' against complete imported objects. 2021-07-09 11:22:15,003 [INFO ] Populated hashes for matcher 'Match by firmware serial number and partition name for vPar, nPar and LPAR' against imported objects. 2021-07-09 11:22:15,034 [INFO ] Executing matcher 'Match by firmware serial number and partition name for vPar, nPar and LPAR' matched 0 complete imported objects. 2021-07-09 11:22:15,034 [INFO ] Executing matcher 'Match by host ID and partition name for zone' against complete imported objects. 2021-07-09 11:22:15,050 [INFO ] Populated hashes for matcher 'Match by host ID and partition name for zone' against imported objects. 2021-07-09 11:22:15,081 [INFO ] Executing matcher 'Match by host ID and partition name for zone' matched 0 complete imported objects. 2021-07-09 11:22:15,081 [INFO ] Executing matcher 'Match by host ID, host identifying number, host type and manufacturer' against complete imported objects. 2021-07-09 11:22:15,112 [INFO ] Populated hashes for matcher 'Match by host ID, host identifying number, host type and manufacturer' against imported objects. 2021-07-09 11:22:15,159 [INFO ] Executing matcher 'Match by host ID, host identifying number, host type and manufacturer' matched 0 complete imported objects. 2021-07-09 11:22:15,159 [INFO ] Executing matcher 'Match by host identifying number, host type and manufacturer when host ID not provided' against complete imported objects. 2021-07-09 11:22:15,175 [INFO ] Populated hashes for matcher 'Match by host identifying number, host type and manufacturer when host ID not provided' against imported objects. 2021-07-09 11:22:15,222 [INFO ] Executing matcher 'Match by host identifying number, host type and manufacturer when host ID not provided' matched 0 complete imported objects. 2021-07-09 11:22:15,222 [INFO ] Executing matcher 'Match by host ID, host identifying number and host type' against complete imported objects. 2021-07-09 11:22:15,253 [INFO ] Populated hashes for matcher 'Match by host ID, host identifying number and host type' against imported objects. 2021-07-09 11:22:15,284 [INFO ] Executing matcher 'Match by host ID, host identifying number and host type' matched 0 complete imported objects. 2021-07-09 11:22:15,284 [INFO ] Executing matcher 'Match by host identifying number and host type' against complete imported objects. 2021-07-09 11:22:15,315 [INFO ] Populated hashes for matcher 'Match by host identifying number and host type' against imported objects. 2021-07-09 11:22:15,347 [INFO ] Executing matcher 'Match by host identifying number and host type' matched 0 complete imported objects. 2021-07-09 11:22:15,347 [INFO ] Executing matcher 'Match by host ID, host identifying number and manufacturer' against complete imported objects. 2021-07-09 11:22:15,378 [INFO ] Populated hashes for matcher 'Match by host ID, host identifying number and manufacturer' against imported objects. 2021-07-09 11:22:15,425 [INFO ] Executing matcher 'Match by host ID, host identifying number and manufacturer' matched 0 complete imported objects. 2021-07-09 11:22:15,425 [INFO ] Executing matcher 'Match by host identifying number and manufacturer' against complete imported objects. 2021-07-09 11:22:15,440 [INFO ] Populated hashes for matcher 'Match by host identifying number and manufacturer' against imported objects. 2021-07-09 11:22:15,487 [INFO ] Executing matcher 'Match by host identifying number and manufacturer' matched 56 complete imported objects. 2021-07-09 11:22:15,487 [INFO ] Executing matcher 'Match by host ID and host identifying number' against complete imported objects. 2021-07-09 11:22:15,503 [INFO ] Populated hashes for matcher 'Match by host ID and host identifying number' against imported objects. 2021-07-09 11:22:15,550 [INFO ] Executing matcher 'Match by host ID and host identifying number' matched 0 complete imported objects. 2021-07-09 11:22:15,550 [INFO ] Executing matcher 'Match by host identifying number' against complete imported objects. 2021-07-09 11:22:15,550 [INFO ] Populated hashes for matcher 'Match by host identifying number' against imported objects. 2021-07-09 11:22:15,597 [INFO ] Executing matcher 'Match by host identifying number' matched 56 complete imported objects. 2021-07-09 11:22:15,597 [INFO ] Executing matcher 'Match by serial number and computer name' against complete imported objects. 2021-07-09 11:22:15,612 [INFO ] Populated hashes for matcher 'Match by serial number and computer name' against imported objects. 2021-07-09 11:22:15,862 [INFO ] Executing matcher 'Match by serial number and computer name' matched 9281 complete imported objects. 2021-07-09 11:22:15,862 [INFO ] Executing matcher 'Match by ILMT Agent ID' against complete imported objects. 2021-07-09 11:22:15,862 [INFO ] Populated hashes for matcher 'Match by ILMT Agent ID' against imported objects. 2021-07-09 11:22:15,894 [INFO ] Executing matcher 'Match by ILMT Agent ID' matched 0 complete imported objects. 2021-07-09 11:22:15,894 [INFO ] Executing matcher 'Match by instance ID' against complete imported objects. 2021-07-09 11:22:15,925 [INFO ] Populated hashes for matcher 'Match by instance ID' against imported objects. 2021-07-09 11:22:15,940 [INFO ] Executing matcher 'Match by instance ID' matched 0 complete imported objects. 2021-07-09 11:22:15,940 [INFO ] Finished matching complete imported objects. 2021-07-09 11:22:15,940 [INFO ] Identifying unmatched complete imported objects. 2021-07-09 11:22:15,940 [INFO ] Identified 0 unmatched complete imported objects. 2021-07-09 11:22:15,940 [INFO ] Transitively closing complete imported objects. 2021-07-09 11:22:15,940 [INFO ] Transitively closed complete imported objects. 2021-07-09 11:22:15,940 [INFO ] Identify set of unique complete imported objects. 2021-07-09 11:22:16,034 [INFO ] Identified 5268 sets of unique complete imported objects. 2021-07-09 11:22:16,034 [INFO ] Matching incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Executing matcher 'Weak match by computer name and domain' against incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Populated hashes for matcher 'Weak match by computer name and domain' against incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Executing matcher 'Weak match by computer name and domain' matched 1 incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Executing matcher 'Weak match by computer name' against incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Populated hashes for matcher 'Weak match by computer name' against incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Executing matcher 'Weak match by computer name' matched 1 incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Transitively closing incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Transitively closed incomplete imported objects. 2021-07-09 11:22:16,050 [INFO ] Executing matcher 'Weak match by computer name and domain' against incomplete imported objects to complete imported objects. 2021-07-09 11:22:16,081 [INFO ] Populated hashes for matcher 'Weak match by computer name and domain' against incomplete imported objects to complete imported objects. 2021-07-09 11:22:16,081 [INFO ] Executing matcher 'Weak match by computer name and domain' matched 1 incomplete imported objects to complete imported objects. 2021-07-09 11:22:16,081 [INFO ] Executing matcher 'Weak match by computer name' against incomplete imported objects to complete imported objects. 2021-07-09 11:22:16,081 [INFO ] Populated hashes for matcher 'Weak match by computer name' against incomplete imported objects to complete imported objects. 2021-07-09 11:22:16,081 [INFO ] Executing matcher 'Weak match by computer name' matched 1 incomplete imported objects to complete imported objects. 2021-07-09 11:22:16,081 [INFO ] Matching unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'match remnant by computer name and domain' against unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Populated hashes for matcher 'match remnant by computer name and domain' against unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'match remnant by computer name and domain' matched 0 unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name and domain and untrusted serial number' against unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Populated hashes for matcher 'Match remnant by computer name and domain and untrusted serial number' against unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name and domain and untrusted serial number' matched 0 unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name' against unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Populated hashes for matcher 'Match remnant by computer name' against unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name' matched 0 unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Transitively closing unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Transitively closed unmatched imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'match remnant by computer name and domain' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Populated hashes for matcher 'match remnant by computer name and domain' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'match remnant by computer name and domain' matched 0 unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name and domain and untrusted serial number' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Populated hashes for matcher 'Match remnant by computer name and domain and untrusted serial number' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name and domain and untrusted serial number' matched 0 unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Populated hashes for matcher 'Match remnant by computer name' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match remnant by computer name' matched 0 unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:16,097 [INFO ] Saving unmatched imported object matches. 2021-07-09 11:22:16,097 [INFO ] Saved unmatched imported object matches. 2021-07-09 11:22:16,097 [INFO ] Saving distinct incomplete imported object matches. 2021-07-09 11:22:16,097 [INFO ] Saved distinct incomplete imported object matches. 2021-07-09 11:22:16,097 [INFO ] Matching compliance objects. 2021-07-09 11:22:16,097 [INFO ] Executing matcher 'Match VMware ESX Servers by computer name and domain ID' against compliance objects. 2021-07-09 11:22:16,128 [INFO ] Populated hashes for matcher 'Match VMware ESX Servers by computer name and domain ID' against compliance objects. 2021-07-09 11:22:16,175 [INFO ] Executing matcher 'Match VMware ESX Servers by computer name and domain ID' matched 56 compliance objects. 2021-07-09 11:22:16,175 [INFO ] Executing matcher 'Match by manufacturer, model, firmware serial number and host ID for physical computer' against compliance objects. 2021-07-09 11:22:16,206 [INFO ] Populated hashes for matcher 'Match by manufacturer, model, firmware serial number and host ID for physical computer' against compliance objects. 2021-07-09 11:22:16,269 [INFO ] Executing matcher 'Match by manufacturer, model, firmware serial number and host ID for physical computer' matched 0 compliance objects. 2021-07-09 11:22:16,269 [INFO ] Executing matcher 'Match by manufacturer, model and firmware serial number for physical computer with no host ID' against compliance objects. 2021-07-09 11:22:16,284 [INFO ] Populated hashes for matcher 'Match by manufacturer, model and firmware serial number for physical computer with no host ID' against compliance objects. 2021-07-09 11:22:16,362 [INFO ] Executing matcher 'Match by manufacturer, model and firmware serial number for physical computer with no host ID' matched 0 compliance objects. 2021-07-09 11:22:16,362 [INFO ] Executing matcher 'Match by manufacturer, host type, firmware serial number and host ID for physical computer' against compliance objects. 2021-07-09 11:22:16,394 [INFO ] Populated hashes for matcher 'Match by manufacturer, host type, firmware serial number and host ID for physical computer' against compliance objects. 2021-07-09 11:22:16,440 [INFO ] Executing matcher 'Match by manufacturer, host type, firmware serial number and host ID for physical computer' matched 0 compliance objects. 2021-07-09 11:22:16,440 [INFO ] Executing matcher 'Match by manufacturer, host type and firmware serial number for physical computer with no host ID' against compliance objects. 2021-07-09 11:22:16,456 [INFO ] Populated hashes for matcher 'Match by manufacturer, host type and firmware serial number for physical computer with no host ID' against compliance objects. 2021-07-09 11:22:16,534 [INFO ] Executing matcher 'Match by manufacturer, host type and firmware serial number for physical computer with no host ID' matched 0 compliance objects. 2021-07-09 11:22:16,534 [INFO ] Executing matcher 'Match by machine ID for physical computer' against compliance objects. 2021-07-09 11:22:16,534 [INFO ] Populated hashes for matcher 'Match by machine ID for physical computer' against compliance objects. 2021-07-09 11:22:16,581 [INFO ] Executing matcher 'Match by machine ID for physical computer' matched 0 compliance objects. 2021-07-09 11:22:16,581 [INFO ] Executing matcher 'Match by manufacturer, host ID and computer name for physical computer' against compliance objects. 2021-07-09 11:22:16,597 [INFO ] Populated hashes for matcher 'Match by manufacturer, host ID and computer name for physical computer' against compliance objects. 2021-07-09 11:22:16,675 [INFO ] Executing matcher 'Match by manufacturer, host ID and computer name for physical computer' matched 0 compliance objects. 2021-07-09 11:22:16,675 [INFO ] Executing matcher 'Match by partition ID for LPAR, vPar and zone' against compliance objects. 2021-07-09 11:22:16,675 [INFO ] Populated hashes for matcher 'Match by partition ID for LPAR, vPar and zone' against compliance objects. 2021-07-09 11:22:16,722 [INFO ] Executing matcher 'Match by partition ID for LPAR, vPar and zone' matched 0 compliance objects. 2021-07-09 11:22:16,722 [INFO ] Executing matcher 'Match by firmware serial number and partition number for LPAR' against compliance objects. 2021-07-09 11:22:16,737 [INFO ] Populated hashes for matcher 'Match by firmware serial number and partition number for LPAR' against compliance objects. 2021-07-09 11:22:16,769 [INFO ] Executing matcher 'Match by firmware serial number and partition number for LPAR' matched 0 compliance objects. 2021-07-09 11:22:16,769 [INFO ] Executing matcher 'Match by machine ID and partition number for LPAR' against compliance objects. 2021-07-09 11:22:16,784 [INFO ] Populated hashes for matcher 'Match by machine ID and partition number for LPAR' against compliance objects. 2021-07-09 11:22:16,815 [INFO ] Executing matcher 'Match by machine ID and partition number for LPAR' matched 0 compliance objects. 2021-07-09 11:22:16,815 [INFO ] Executing matcher 'Match by machine ID and partition name for vPar, nPar and LPAR' against compliance objects. 2021-07-09 11:22:16,815 [INFO ] Populated hashes for matcher 'Match by machine ID and partition name for vPar, nPar and LPAR' against compliance objects. 2021-07-09 11:22:16,847 [INFO ] Executing matcher 'Match by machine ID and partition name for vPar, nPar and LPAR' matched 0 compliance objects. 2021-07-09 11:22:16,847 [INFO ] Executing matcher 'Match by firmware serial number and partition name for vPar, nPar and LPAR' against compliance objects. 2021-07-09 11:22:16,862 [INFO ] Populated hashes for matcher 'Match by firmware serial number and partition name for vPar, nPar and LPAR' against compliance objects. 2021-07-09 11:22:16,925 [INFO ] Executing matcher 'Match by firmware serial number and partition name for vPar, nPar and LPAR' matched 0 compliance objects. 2021-07-09 11:22:16,925 [INFO ] Executing matcher 'Match by host ID and partition name for zone' against compliance objects. 2021-07-09 11:22:16,925 [INFO ] Populated hashes for matcher 'Match by host ID and partition name for zone' against compliance objects. 2021-07-09 11:22:16,956 [INFO ] Executing matcher 'Match by host ID and partition name for zone' matched 0 compliance objects. 2021-07-09 11:22:16,956 [INFO ] Executing matcher 'Match by host ID, host identifying number, host type and manufacturer' against compliance objects. 2021-07-09 11:22:16,987 [INFO ] Populated hashes for matcher 'Match by host ID, host identifying number, host type and manufacturer' against compliance objects. 2021-07-09 11:22:17,019 [INFO ] Executing matcher 'Match by host ID, host identifying number, host type and manufacturer' matched 0 compliance objects. 2021-07-09 11:22:17,019 [INFO ] Executing matcher 'Match by host identifying number, host type and manufacturer when host ID not provided' against compliance objects. 2021-07-09 11:22:17,034 [INFO ] Populated hashes for matcher 'Match by host identifying number, host type and manufacturer when host ID not provided' against compliance objects. 2021-07-09 11:22:17,081 [INFO ] Executing matcher 'Match by host identifying number, host type and manufacturer when host ID not provided' matched 0 compliance objects. 2021-07-09 11:22:17,081 [INFO ] Executing matcher 'Match by host ID, host identifying number and host type' against compliance objects. 2021-07-09 11:22:17,097 [INFO ] Populated hashes for matcher 'Match by host ID, host identifying number and host type' against compliance objects. 2021-07-09 11:22:17,144 [INFO ] Executing matcher 'Match by host ID, host identifying number and host type' matched 0 compliance objects. 2021-07-09 11:22:17,144 [INFO ] Executing matcher 'Match by host identifying number and host type' against compliance objects. 2021-07-09 11:22:17,144 [INFO ] Populated hashes for matcher 'Match by host identifying number and host type' against compliance objects. 2021-07-09 11:22:17,190 [INFO ] Executing matcher 'Match by host identifying number and host type' matched 0 compliance objects. 2021-07-09 11:22:17,190 [INFO ] Executing matcher 'Match by host ID, host identifying number and manufacturer' against compliance objects. 2021-07-09 11:22:17,222 [INFO ] Populated hashes for matcher 'Match by host ID, host identifying number and manufacturer' against compliance objects. 2021-07-09 11:22:17,253 [INFO ] Executing matcher 'Match by host ID, host identifying number and manufacturer' matched 0 compliance objects. 2021-07-09 11:22:17,253 [INFO ] Executing matcher 'Match by host identifying number and manufacturer' against compliance objects. 2021-07-09 11:22:17,269 [INFO ] Populated hashes for matcher 'Match by host identifying number and manufacturer' against compliance objects. 2021-07-09 11:22:17,315 [INFO ] Executing matcher 'Match by host identifying number and manufacturer' matched 0 compliance objects. 2021-07-09 11:22:17,315 [INFO ] Executing matcher 'Match by host ID and host identifying number' against compliance objects. 2021-07-09 11:22:17,331 [INFO ] Populated hashes for matcher 'Match by host ID and host identifying number' against compliance objects. 2021-07-09 11:22:17,362 [INFO ] Executing matcher 'Match by host ID and host identifying number' matched 0 compliance objects. 2021-07-09 11:22:17,362 [INFO ] Executing matcher 'Match by host identifying number' against compliance objects. 2021-07-09 11:22:17,378 [INFO ] Populated hashes for matcher 'Match by host identifying number' against compliance objects. 2021-07-09 11:22:17,425 [INFO ] Executing matcher 'Match by host identifying number' matched 0 compliance objects. 2021-07-09 11:22:17,425 [INFO ] Executing matcher 'Match by serial number and computer name' against compliance objects. 2021-07-09 11:22:17,425 [INFO ] Populated hashes for matcher 'Match by serial number and computer name' against compliance objects. 2021-07-09 11:22:17,659 [INFO ] Executing matcher 'Match by serial number and computer name' matched 5212 compliance objects. 2021-07-09 11:22:17,659 [INFO ] Executing matcher 'Match by ILMT Agent ID' against compliance objects. 2021-07-09 11:22:17,659 [INFO ] Populated hashes for matcher 'Match by ILMT Agent ID' against compliance objects. 2021-07-09 11:22:17,659 [INFO ] Executing matcher 'Match by ILMT Agent ID' matched 0 compliance objects. 2021-07-09 11:22:17,659 [INFO ] Executing matcher 'Match by instance ID' against compliance objects. 2021-07-09 11:22:17,675 [INFO ] Populated hashes for matcher 'Match by instance ID' against compliance objects. 2021-07-09 11:22:17,675 [INFO ] Executing matcher 'Match by instance ID' matched 0 compliance objects. 2021-07-09 11:22:17,675 [INFO ] Executing matcher 'Weak match by computer name and domain' against compliance objects. 2021-07-09 11:22:17,690 [INFO ] Populated hashes for matcher 'Weak match by computer name and domain' against compliance objects. 2021-07-09 11:22:17,690 [INFO ] Executing matcher 'Weak match by computer name and domain' matched 1 compliance objects. 2021-07-09 11:22:17,690 [INFO ] Executing matcher 'Weak match by computer name' against compliance objects. 2021-07-09 11:22:17,690 [INFO ] Populated hashes for matcher 'Weak match by computer name' against compliance objects. 2021-07-09 11:22:17,690 [INFO ] Executing matcher 'Weak match by computer name' matched 0 compliance objects. 2021-07-09 11:22:17,690 [INFO ] Executing matcher 'match remnant by computer name and domain' against compliance objects. 2021-07-09 11:22:17,706 [INFO ] Populated hashes for matcher 'match remnant by computer name and domain' against compliance objects. 2021-07-09 11:22:17,706 [INFO ] Executing matcher 'match remnant by computer name and domain' matched 0 compliance objects. 2021-07-09 11:22:17,706 [INFO ] Executing matcher 'Match remnant by computer name and domain and untrusted serial number' against compliance objects. 2021-07-09 11:22:17,722 [INFO ] Populated hashes for matcher 'Match remnant by computer name and domain and untrusted serial number' against compliance objects. 2021-07-09 11:22:17,722 [INFO ] Executing matcher 'Match remnant by computer name and domain and untrusted serial number' matched 0 compliance objects. 2021-07-09 11:22:17,722 [INFO ] Executing matcher 'Match remnant by computer name' against compliance objects. 2021-07-09 11:22:17,722 [INFO ] Populated hashes for matcher 'Match remnant by computer name' against compliance objects. 2021-07-09 11:22:17,722 [INFO ] Executing matcher 'Match remnant by computer name' matched 0 compliance objects. 2021-07-09 11:22:17,722 [INFO ] Finished matching objects. 2021-07-09 11:22:17,722 [INFO ] Saving results of computer matching. 2021-07-09 11:22:18,394 [INFO ] Saved results of computer matching. 2021-07-09 11:22:18,394 [INFO ] Successfully matched 9282 imported computers to existing computers. 2021-07-09 11:22:18,394 [INFO ] 0 computers were not matched to existing computers and will be created. 2021-07-09 11:22:18,394 [INFO ] Successfully processed in 4 seconds 2021-07-09 11:22:18,394 [INFO ] Populate temp table 2021-07-09 11:22:18,690 [INFO ] Added 0 ImportedComputers in to temp table for processing 2021-07-09 11:22:18,690 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:18,690 [INFO ] Process results from computer matching 2021-07-09 11:22:19,176 [INFO ] Matched 9282 imported computer records to existing compliance computers 2021-07-09 11:22:19,176 [INFO ] Updated 9282 incomplete computer records to refer to their complete primary computer record 2021-07-09 11:22:19,176 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:19,176 [INFO ] ProcessComputersWithDuplicateSerialNo 2021-07-09 11:22:19,518 [INFO ] Extracted 0 computer serial numbers with duplicate count over all source connections 2021-07-09 11:22:19,534 [INFO ] Extracted 0 computer serial numbers with maximum duplicate count over all source connections 2021-07-09 11:22:19,534 [INFO ] Ranked 0 imported computers based on primary connection and latest inventory date 2021-07-09 11:22:19,534 [INFO ] Extracted 0 imported computers for duplicate and compliance computer identification 2021-07-09 11:22:19,534 [INFO ] Matched 0 imported computers with duplicate serial number 2021-07-09 11:22:19,534 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:19,534 [INFO ] WriteComputers - remove obsolete computers with duplicate serial numbers 2021-07-09 11:22:19,534 [INFO ] Removed 0 obsolete computers with duplicate serial numbers 2021-07-09 11:22:19,534 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:19,534 [INFO ] WriteComputers - AutoCreateRemoteDevices evaluation to prevent remote device creation 2021-07-09 11:22:19,550 [INFO ] Prevented 0 remote dummy devices from being created 2021-07-09 11:22:19,550 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:19,550 [INFO ] WriteComputers - Remove XenDesktop VDI devices that are known to be non-persistent 2021-07-09 11:22:19,612 [INFO ] Prevented 0 non-persistent VDI devices from being created 2021-07-09 11:22:19,612 [INFO ] Cleared 0 non-persistent VDI imported computer records from linking to compliance computer records 2021-07-09 11:22:19,612 [INFO ] Added 0 non-persistent VDI imported computer records to ImportedMIssingComputer 2021-07-09 11:22:19,612 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:19,612 [INFO ] WriteComputers - update user details 2021-07-09 11:22:19,893 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:19,893 [INFO ] WriteComputers - update last logged on user details 2021-07-09 11:22:20,393 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:20,393 [INFO ] WriteComputers - set calculated user 2021-07-09 11:22:20,737 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:20,737 [INFO ] WriteComputers - Determine computers to be inserted 2021-07-09 11:22:20,737 [INFO ] Identified 0 new computers for insertion. 2021-07-09 11:22:20,737 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:20,737 [INFO ] WriteComputers - Enforce device and server license limit restriction in staging 2021-07-09 11:22:20,768 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:20,768 [INFO ] WriteComputers - Insert new computers 2021-07-09 11:22:21,112 [INFO ] Added 0 Computers from the source database connections. 2021-07-09 11:22:21,128 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,128 [INFO ] WriteComputers - match new inserted computers back to temporary imported computers 2021-07-09 11:22:21,143 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,143 [INFO ] WriteComputers - match new imported computers to compliance computers 2021-07-09 11:22:21,253 [INFO ] Updated 9282 imported computers with data from temprary imported computer table 2021-07-09 11:22:21,253 [INFO ] Updated 0 imported computers with data from temprary duplicate computer information table 2021-07-09 11:22:21,253 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,253 [INFO ] WriteComputers - rank computers for update 2021-07-09 11:22:21,331 [INFO ] Ranked 9282 imported computers 2021-07-09 11:22:21,331 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,331 [INFO ] WriteComputers - stale inventory thresholds 2021-07-09 11:22:21,347 [INFO ] Found 170 stale inventory records using manually set thresholds 2021-07-09 11:22:21,347 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,347 [INFO ] WriteComputers - stale inventory identification 2021-07-09 11:22:21,362 [INFO ] Found 0 stale inventory records for option - ignore If another data source reports more recent inventory for a device 2021-07-09 11:22:21,362 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,362 [INFO ] WriteComputers - stale inventory from missing dates 2021-07-09 11:22:21,378 [INFO ] Found 0 stale inventory records due to missing inventory dates 2021-07-09 11:22:21,378 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,378 [INFO ] WriteComputers - stale inventory - keep latest inventory 2021-07-09 11:22:21,393 [INFO ] Keep stale records as the only inventory source 170 2021-07-09 11:22:21,393 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,393 [INFO ] WriteComputers - ExpiredImportedComputer 2021-07-09 11:22:21,393 [INFO ] Removed 0 ExpiredImportedComputer records due to incoming data 2021-07-09 11:22:21,393 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,393 [INFO ] WriteComputers - new ExpiredImportedComputer records 2021-07-09 11:22:21,409 [INFO ] Inserted 0 new ExpiredImportedComputer records 2021-07-09 11:22:21,409 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,409 [INFO ] WriteComputers - remove stale inventory records 2021-07-09 11:22:21,456 [INFO ] Removed 0 ExpiredImportedComputer records due to source data no longer returning them 2021-07-09 11:22:21,456 [INFO ] Removed 0 ImportedComputer records due to stale inventory 2021-07-09 11:22:21,456 [INFO ] Removed 0 ExpiredImportedComputer records that are no longer stale 2021-07-09 11:22:21,456 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,456 [INFO ] WriteComputers - update computer properties from multiple sources 2021-07-09 11:22:21,643 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:21,643 [INFO ] WriteComputers - update computers that have changed in the source 2021-07-09 11:22:23,206 [INFO ] Only Updated 0 Computers that have changed in the source database connections. 2021-07-09 11:22:23,206 [INFO ] Successfully processed in 1 second 2021-07-09 11:22:23,206 [INFO ] WriteComputers - update computer connection links 2021-07-09 11:22:23,378 [INFO ] Removed 0 records from ComplianceComputerConnection 2021-07-09 11:22:23,378 [INFO ] Added 0 records into ComplianceComputerConnection 2021-07-09 11:22:23,378 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,378 [INFO ] WriteMobileDevice 2021-07-09 11:22:23,456 [INFO ] Updated 0 mobile device records. 2021-07-09 11:22:23,456 [INFO ] Added 0 mobile device records. 2021-07-09 11:22:23,456 [INFO ] Removed 0 mobile device records. 2021-07-09 11:22:23,456 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,456 [INFO ] ImportCustomProperties 2021-07-09 11:22:23,565 [INFO ] Updated 0 Computer custom property values that have changed in the source database connections. 2021-07-09 11:22:23,565 [INFO ] Updated 0 Asset custom property values that have changed in the source database connections. 2021-07-09 11:22:23,565 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,565 [INFO ] SetCalculatedUserIDsWhenLastLoggedOnUserIsSet 2021-07-09 11:22:23,581 [INFO ] Updated 0 computer records to have calculated users based on last logged on users. 2021-07-09 11:22:23,581 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,581 [INFO ] RemoveRemoteDevicesIfAutoCreateRemoteDevicesIsDisabled 2021-07-09 11:22:23,581 [INFO ] Removed 0 Remote Devices due to auto-creation setting is disabled. 2021-07-09 11:22:23,581 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,581 [INFO ] CreateRequiredRemoteACLDevices 2021-07-09 11:22:23,612 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,612 [INFO ] ImportTDSComputer 2021-07-09 11:22:23,612 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,612 [INFO ] CreateRequiredRemoteACLDevices-RemoteUsersWithNoPrimaryDevice 2021-07-09 11:22:23,643 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,643 [INFO ] ResetImporterWriterForceComputerUpdate 2021-07-09 11:22:23,643 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,643 [INFO ] CreateRequiredRemoteACLDevices-Remove remote user based devices that are no longer required 2021-07-09 11:22:23,643 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,643 [INFO ] CreateRequiredRemoteACLDevices-Remove remote user based devices from compliance computer when the remote user doesn't exists. 2021-07-09 11:22:23,659 [INFO ] Removed 0 remote user based devices, for users that no longer exists 2021-07-09 11:22:23,659 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,659 [INFO ] CreateRequiredRemoteACLDevices-Add new remote user based devices 2021-07-09 11:22:23,893 [INFO ] Updated inventory date for 0 remote user based devices 2021-07-09 11:22:23,893 [INFO ] Added 0 new remote user based devices 2021-07-09 11:22:23,893 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,893 [INFO ] GetKnownAccessModes 2021-07-09 11:22:23,893 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,893 [INFO ] AddVDISites 2021-07-09 11:22:23,925 [INFO ] Found 0 VDI site(s). 2021-07-09 11:22:23,925 [INFO ] Removed 0 obsolete VDI site(s). 2021-07-09 11:22:23,925 [INFO ] Created 0 VDI site(s). 2021-07-09 11:22:23,925 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,925 [INFO ] AddVDIGroups 2021-07-09 11:22:23,956 [INFO ] Removed 0 obsolete VDI Groups. 2021-07-09 11:22:23,956 [INFO ] Added 0 new VDI Groups. 2021-07-09 11:22:23,956 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:23,956 [INFO ] CreateVDITemplates 2021-07-09 11:22:24,284 [INFO ] Removed 0 VDI template ComplianceComputer records. 2021-07-09 11:22:24,284 [INFO ] Added 0 new VDI templates. 2021-07-09 11:22:24,284 [INFO ] Added 0 new VDI template devices. 2021-07-09 11:22:24,284 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,284 [INFO ] CreateVDIDevices 2021-07-09 11:22:24,362 [INFO ] Found 0 VDI device records. 2021-07-09 11:22:24,362 [INFO ] Removed 0 retired VDI devices. 2021-07-09 11:22:24,362 [INFO ] Marked 0 VDI devices as retired. 2021-07-09 11:22:24,362 [INFO ] Updated 0 VDI devices. 2021-07-09 11:22:24,362 [INFO ] Added 0 new VDI devices. 2021-07-09 11:22:24,362 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,362 [INFO ] CreateVDIUsers 2021-07-09 11:22:24,393 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,393 [INFO ] CreateVDIEndpointAccessRecords 2021-07-09 11:22:24,425 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,425 [INFO ] MergeVDIDeviceEvidenceToTemplates 2021-07-09 11:22:24,596 [INFO ] Found 0 VDI device records that can be merged to VDI templates. 2021-07-09 11:22:24,596 [INFO ] Merged 0 VDI device file evidence records to their VDI template. 2021-07-09 11:22:24,596 [INFO ] Merged 0 VDI device installer evidence records to their VDI template. 2021-07-09 11:22:24,596 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,596 [INFO ] Writing data for 'Computer' successfully processed in 13 seconds. 2021-07-09 11:22:24,612 [INFO ] Released application lock Writer_Source_Computer_ALL 2021-07-09 11:22:24,612 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:24,612 [INFO ] Writing data for 'VirtualMachine' 2021-07-09 11:22:24,612 [INFO ] CreateTempTableWithAllVMPoolConnectionsImported 2021-07-09 11:22:24,628 [INFO ] Created various temporary working tables needed for succeeding operations 2021-07-09 11:22:24,628 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,628 [INFO ] CreateTempTableForVMPoolCalculations 2021-07-09 11:22:24,706 [INFO ] Created pre-calculated VM Pools temporary working data needed for succeeding operations 2021-07-09 11:22:24,706 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,706 [INFO ] WriteVMPools 2021-07-09 11:22:24,753 [INFO ] Processing VM Pools from connection 2 2021-07-09 11:22:24,753 [INFO ] Added 0 new VM pools 2021-07-09 11:22:24,753 [INFO ] Updated 152 VM pools 2021-07-09 11:22:24,753 [INFO ] Unlinked 0 VMs from VM pools ready for VM pools removal 2021-07-09 11:22:24,753 [INFO ] Removed 0 VM pools that no longer exists from data sources 2021-07-09 11:22:24,753 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,753 [INFO ] CalculatePathStructure 2021-07-09 11:22:24,815 [INFO ] Updated 152 VM pools with calculated path structures 2021-07-09 11:22:24,815 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,815 [INFO ] CreateTempTableWithAllVirtualMachineConnectionsImported 2021-07-09 11:22:24,831 [INFO ] Created various VM related temporary data needed for succeeding processes 2021-07-09 11:22:24,831 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:24,831 [INFO ] ProcessKnownLinks 2021-07-09 11:22:25,159 [INFO ] Updated 0 VMs where they already have computer records 2021-07-09 11:22:25,175 [INFO ] Added 0 VMs where they already have computer records 2021-07-09 11:22:25,175 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:25,175 [INFO ] CreateTempTableForVirtualMachineCalculations 2021-07-09 11:22:25,206 [INFO ] Readying 469 VMs for processing 2021-07-09 11:22:25,206 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:25,206 [INFO ] WriteVirtualMachines 2021-07-09 11:22:32,143 [INFO ] 2021-07-09 11:22:25.283: Starting WriteVirtualMachines 2021-07-09 11:22:32,143 [INFO ] 2021-07-09 11:22:25.300: Found 469 VMs to be updated with new VM pool IDs and VM types 2021-07-09 11:22:32,143 [INFO ] 2021-07-09 11:22:25.300: Found 0 VMs to be removed with invalid types 2021-07-09 11:22:32,143 [INFO ] 2021-07-09 11:22:25.300: Found 0 KVM VMs which will be compared with UUID endianness loose matching 2021-07-09 11:22:32,143 [WARN ] Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'IX_TmpVirtualMachine_UUID' has maximum length of 8000 bytes. For some combination of large values, the insert/update operation will fail. 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.407: Processing 365 existing VMs for matching 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.423: 1 - Processing VMs from connection 2 2021-07-09 11:22:32,159 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.423: 1 - Processing VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.550: Updating 365 Records with Unique UUIDs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.593: Updating 0 Temp VirtualMachineComputerData 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.610: Inserting 365 into temp VirtualMachineComputerData 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:25.843: Updated 0 existing VMs with unique UUID match 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:26.110: Updated 0 Computers with their corresponding VM data 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.593: Updated 365 Computers to have the same enterprise groups with their VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.610: Updated 0 Assets to have the same enterprise groups with their linked VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.610: Updated 0 existing VMs with unique name and host match 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.610: 2 - Processing VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.673: Updating 0 Records with Unique UUIDs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.690: Updating 0 Temp VirtualMachineComputerData 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.703: Inserting 0 into temp VirtualMachineComputerData 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:27.940: Updated 0 existing VMs with unique UUID match 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.080: Updated 0 Computers with their corresponding VM data 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.080: Updated 0 Computers to have the same enterprise groups with their VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.080: Updated 0 Assets to have the same enterprise groups with their linked VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.110: Found 104 new VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.173: Updating Temp Compliance Computer 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.283: Found 0 existing Computers with type VM that dont have VM records 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.283: Found 0 Computers with type VM having no VM data but look like VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:28.300: Retain AWS EC2 Records in temp table v 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:29.720: Beginning VM matching process : 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:29.737: Found 0 VMs needed to unlinked from Computers as part of clean up process of bad data state 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:29.750: Found 0 VMs needed to break the link from Computers with mismatched serial numbers 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:29.970: Updated the serial numbers of 0 Computers linked to VMs with mismatched UUIDs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:30.000: Found 0 VMs that are considered duplicate due to same UUID 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:30.237: Synced 0 Computers enterprise groups to their linked Assets 2021-07-09 11:22:32,159 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:30.940: Linking VM Based on UUID to match with computer Serial number 2021-07-09 11:22:32,159 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:30.953: Detected 0 KVM VMs which will be matched with endianness loose matching 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:31.190: Set the status of 0 VMs to Duplicated 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:31.313: @UpdatedRowCount: 0 @NumberOfLoops: 1 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:31.550: Relinked 368 VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:31.690: Updated UUID of 0 VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:31.877: Added 0 new VMs to VirtualMachine table 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:31.953: Updated the type of 0 Computers to VM 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.000: Updated the type of 0 Computers to VM Host 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.033: Updated the type of 0 VM computers to Computer 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.063: Removed 0 Computers which are no longer linked to VMs 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.063: Custom properties: Removed 0 computers from processing because they didnt change or have no properties 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.063: Added 0 new Computer custom properties 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.097: Updated 0 computer custom property values because of computer type changes 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.097: Removed 0 old computer custom property values because of computer type changes 2021-07-09 11:22:32,159 [INFO ] 2021-07-09 11:22:32.143: Ending WriteVirtualMachines 2021-07-09 11:22:32,159 [INFO ] Successfully processed in 6 seconds 2021-07-09 11:22:32,159 [INFO ] ClusterSetup 2021-07-09 11:22:32,159 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,159 [INFO ] Perform cluster matching 2021-07-09 11:22:32,159 [INFO ] Running cluster matching engine. 2021-07-09 11:22:32,159 [INFO ] Initializing cluster matching. 2021-07-09 11:22:32,174 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:32,190 [INFO ] Initialized cluster matching. 2021-07-09 11:22:32,190 [INFO ] Matching complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType and ExternalName' against complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match by ClusterType and ExternalName' against imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType and ExternalName' matched 8 complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType, Name and Namespace' against complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match by ClusterType, Name and Namespace' against imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType, Name and Namespace' matched 8 complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match strictly by ClusterType and Name when ExternalName and Namespace not provided' against complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match strictly by ClusterType and Name when ExternalName and Namespace not provided' against imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match strictly by ClusterType and Name when ExternalName and Namespace not provided' matched 0 complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Finished matching complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Identifying unmatched complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Identified 0 unmatched complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Transitively closing complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Transitively closed complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Identify set of unique complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Identified 8 sets of unique complete imported objects. 2021-07-09 11:22:32,190 [INFO ] Matching incomplete imported objects. 2021-07-09 11:22:32,190 [INFO ] Transitively closing incomplete imported objects. 2021-07-09 11:22:32,190 [INFO ] Transitively closed incomplete imported objects. 2021-07-09 11:22:32,190 [INFO ] Matching unmatched imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match Unmatched by ClusterType and Name' against unmatched imported objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match Unmatched by ClusterType and Name' against unmatched imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match Unmatched by ClusterType and Name' matched 0 unmatched imported objects. 2021-07-09 11:22:32,190 [INFO ] Transitively closing unmatched imported objects. 2021-07-09 11:22:32,190 [INFO ] Transitively closed unmatched imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match Unmatched by ClusterType and Name' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match Unmatched by ClusterType and Name' against unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match Unmatched by ClusterType and Name' matched 0 unmatched imported objects to distinct incomplete imported objects. 2021-07-09 11:22:32,190 [INFO ] Saving unmatched imported object matches. 2021-07-09 11:22:32,190 [INFO ] Saved unmatched imported object matches. 2021-07-09 11:22:32,190 [INFO ] Saving distinct incomplete imported object matches. 2021-07-09 11:22:32,190 [INFO ] Saved distinct incomplete imported object matches. 2021-07-09 11:22:32,190 [INFO ] Matching compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType and ExternalName' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match by ClusterType and ExternalName' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType and ExternalName' matched 8 compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType, Name and Namespace' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match by ClusterType, Name and Namespace' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match by ClusterType, Name and Namespace' matched 0 compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match strictly by ClusterType and Name when ExternalName and Namespace not provided' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match strictly by ClusterType and Name when ExternalName and Namespace not provided' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match strictly by ClusterType and Name when ExternalName and Namespace not provided' matched 0 compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match Unmatched by ClusterType and Name' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Populated hashes for matcher 'Match Unmatched by ClusterType and Name' against compliance objects. 2021-07-09 11:22:32,190 [INFO ] Executing matcher 'Match Unmatched by ClusterType and Name' matched 0 compliance objects. 2021-07-09 11:22:32,190 [INFO ] Finished matching objects. 2021-07-09 11:22:32,190 [INFO ] Saving results of cluster matching. 2021-07-09 11:22:32,362 [INFO ] Saved results of cluster matching. 2021-07-09 11:22:32,362 [INFO ] Successfully matched 8 imported clusters to existing clusters. 2021-07-09 11:22:32,362 [INFO ] 0 clusters were not matched to existing clusters and will be created. 2021-07-09 11:22:32,362 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,362 [INFO ] ClusterWrite 2021-07-09 11:22:32,424 [INFO ] Deleted 0 cluster(s) that no longer exist(s) 2021-07-09 11:22:32,424 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,424 [INFO ] ManageImportedClusterMembers 2021-07-09 11:22:32,612 [INFO ] Deleted 0 cluster node(s) that no longer exist(s) 2021-07-09 11:22:32,612 [INFO ] Updated information on 0 cluster node(s) 2021-07-09 11:22:32,612 [INFO ] Deleted 0 manual cluster node(s) that have moved to new cluster(s) 2021-07-09 11:22:32,612 [INFO ] Added 0 cluster node(s) from source database connections 2021-07-09 11:22:32,612 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,612 [INFO ] ManageImportedClusterGroups 2021-07-09 11:22:32,612 [INFO ] Deleted 0 cluster group(s) that no longer exist(s) 2021-07-09 11:22:32,612 [INFO ] Added 0 cluster group(s) from source database connections 2021-07-09 11:22:32,612 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,612 [INFO ] ManageImportedClusterGroupMembers 2021-07-09 11:22:32,784 [INFO ] Deleted 0 cluster group membership(s) that no longer exist(s) 2021-07-09 11:22:32,784 [INFO ] Added 0 cluster host group membership(s) from source database connections 2021-07-09 11:22:32,784 [INFO ] Added 0 cluster VM group membership(s) from source database connections 2021-07-09 11:22:32,784 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,784 [INFO ] ManageImportedClusterRules 2021-07-09 11:22:32,784 [INFO ] Deleted 0 cluster affinity rule(s) that no longer exist(s) 2021-07-09 11:22:32,784 [INFO ] Updated 0 cluster affinity rule(s) from source database connections 2021-07-09 11:22:32,784 [INFO ] Added 0 cluster affinity rule(s) from source database connections 2021-07-09 11:22:32,784 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,784 [INFO ] Populate VMHostDataStore 2021-07-09 11:22:32,831 [INFO ] Added 0 VM Host datastores 2021-07-09 11:22:32,831 [INFO ] Deleted 0 VM Host datastores 2021-07-09 11:22:32,831 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,831 [INFO ] Create missing regions, availability zones and instance types 2021-07-09 11:22:32,831 [INFO ] Added 0 new AWS availability zones. 2021-07-09 11:22:32,831 [INFO ] Added 0 new AWS instance types. 2021-07-09 11:22:32,831 [INFO ] Added 0 new AWS regions. 2021-07-09 11:22:32,831 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,831 [INFO ] ReleaseAdditionalApplicationLocks 2021-07-09 11:22:32,831 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,831 [INFO ] Populate VMHostProperty 2021-07-09 11:22:32,924 [INFO ] Added 0 VM Host Property 2021-07-09 11:22:32,924 [INFO ] Deleted 0 VM Host Property 2021-07-09 11:22:32,924 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,924 [INFO ] Writing data for 'VirtualMachine' successfully processed in 8 seconds. 2021-07-09 11:22:32,924 [INFO ] Released application lock Writer_Source_VirtualMachine_ALL 2021-07-09 11:22:32,924 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:32,924 [INFO ] Writing data for 'CloudInstance' 2021-07-09 11:22:32,924 [INFO ] Create temp table for Cloud Service Instance 2021-07-09 11:22:32,924 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,924 [INFO ] Prepare cloud service instance data 2021-07-09 11:22:32,987 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:32,987 [INFO ] Merge data when the field is not available from different sources 2021-07-09 11:22:33,003 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,003 [INFO ] Import cloud service instance data 2021-07-09 11:22:33,128 [INFO ] Updated 0 instances that have changed in the source database connections. 2021-07-09 11:22:33,128 [INFO ] Updated 0 instances to terminated due to missing records in ImportedCloudServiceInstance. 2021-07-09 11:22:33,128 [INFO ] Added 0 instances from the source database connections. 2021-07-09 11:22:33,128 [INFO ] Added 0 records to cloud service instance connections. 2021-07-09 11:22:33,128 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,128 [INFO ] For AWS machines, update additional data to virtual machine and computer 2021-07-09 11:22:33,378 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,378 [INFO ] Sync VMEnabledStateID from CSI to Virtual Machines 2021-07-09 11:22:33,393 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,393 [INFO ] Inserting UUID into lookup table for links between CloudServiceInstance and ComplianceComputer for Azure 2021-07-09 11:22:33,409 [INFO ] Loaded 266 into #MatchingLookup records 2021-07-09 11:22:33,409 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,409 [INFO ] Updating links between CloudServiceInstance and ComplianceComputer using lookup table 2021-07-09 11:22:33,612 [INFO ] Remove 0 NULL InstanceCloudID records from #MatchingLookup. 2021-07-09 11:22:33,612 [INFO ] Remove 0 records from #MatchingLookup. 2021-07-09 11:22:33,612 [INFO ] Unlinked 0 CSI records that were matched not by inventory. 2021-07-09 11:22:33,612 [INFO ] Unlinked 0 CSI records that were no longer matched previously by cloud instance ID. 2021-07-09 11:22:33,612 [INFO ] Updated 0 CCID on CSI records that were matched without inventory before. 2021-07-09 11:22:33,612 [INFO ] Updated 0 CSPID on CC records 2021-07-09 11:22:33,612 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,612 [INFO ] Update CloudServiceInstances with no associated ComplianceComputer using MAC address 2021-07-09 11:22:33,799 [INFO ] Creating temp tables to store temporary CloudServiceInstances 2021-07-09 11:22:33,799 [INFO ] Loaded 5496 #ComplianceComputer records with broken CSV MAC Addresses. 2021-07-09 11:22:33,799 [INFO ] Loaded 0 #CloudServiceInstance records with broken CSV MAC Addresses. 2021-07-09 11:22:33,799 [INFO ] Removed 0 CCs that have duplicate MACAddresses. 2021-07-09 11:22:33,799 [INFO ] Removed 0 CCs that were linked by inventory. 2021-07-09 11:22:33,799 [INFO ] Removed 0 CSIs that have duplicate MACAddresses. 2021-07-09 11:22:33,799 [INFO ] Removed 0 CCs that have duplicate MACAddresses. 2021-07-09 11:22:33,799 [INFO ] Removed 0 Dinstinct CSIs from the final table. 2021-07-09 11:22:33,799 [INFO ] Removed 0 CSI records that have CC that were matched twice. 2021-07-09 11:22:33,799 [INFO ] Removed 0 CSI records that were matched twice. 2021-07-09 11:22:33,799 [INFO ] Updated 0 CCID on CSI records. 2021-07-09 11:22:33,799 [INFO ] Successfully dropped temp tables. 2021-07-09 11:22:33,799 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,799 [INFO ] Delete computers linked to terminated cloud service instances 2021-07-09 11:22:33,815 [INFO ] Updating Imported Missing Computer records linked to terminated instances. 2021-07-09 11:22:33,815 [INFO ] Updated 0 Imported Missing Computers linked to terminated instances. 2021-07-09 11:22:33,815 [INFO ] Inserting compliance computers linked to terminated cloud instances in to Imported Missing Computer table. 2021-07-09 11:22:33,815 [INFO ] Inserted 0 compliance computers linked with terminated cloud instances in to Imported Missing Computer table. 2021-07-09 11:22:33,815 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,815 [INFO ] Set InventoryDates on matched and unmatched instances 2021-07-09 11:22:33,815 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,815 [INFO ] Clean up imported temp table 2021-07-09 11:22:33,815 [INFO ] Delete temp table for Cloud Service Instance. 2021-07-09 11:22:33,815 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,815 [INFO ] Writing data for 'CloudInstance' successfully processed in 0 seconds. 2021-07-09 11:22:33,815 [INFO ] Released application lock Writer_Source_CloudInstance_ALL 2021-07-09 11:22:33,815 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:33,815 [INFO ] Writing data for 'Container' 2021-07-09 11:22:33,815 [INFO ] ContainerSetup 2021-07-09 11:22:33,815 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,815 [INFO ] CreateTempTablesForContainerWriter 2021-07-09 11:22:33,831 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,831 [INFO ] PrepareContainerImages 2021-07-09 11:22:33,846 [INFO ] Added 0 records into #ImportedContainerImage from ImportedContainerImage 2021-07-09 11:22:33,846 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,846 [INFO ] UpdateContainerImageValues 2021-07-09 11:22:33,846 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,846 [INFO ] WriteContainerImages 2021-07-09 11:22:33,878 [INFO ] Updated 0 records in ContainerImage 2021-07-09 11:22:33,878 [INFO ] Updated 0 ContainerImageIDs back to to #ImportedContainerImage 2021-07-09 11:22:33,878 [INFO ] Removed 0 ContainerImage records as they are no longer reported in inventory. 2021-07-09 11:22:33,878 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,878 [INFO ] PrepareContainerData 2021-07-09 11:22:33,878 [INFO ] Added 0 records into #ImportedContainerInstance from ImportedContainerInstance 2021-07-09 11:22:33,878 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,878 [INFO ] WriteContainerData 2021-07-09 11:22:33,893 [INFO ] Removed 0 records from ContainerInstance 2021-07-09 11:22:33,893 [INFO ] Updated 0 records in ContainerInstance 2021-07-09 11:22:33,893 [INFO ] Added 0 records to ContainerInstance 2021-07-09 11:22:33,893 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,893 [INFO ] UpdateImagesLastUsed 2021-07-09 11:22:33,893 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,893 [INFO ] ContainerCleanup 2021-07-09 11:22:33,909 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,909 [INFO ] Writing data for 'Container' successfully processed in 0 seconds. 2021-07-09 11:22:33,909 [INFO ] Released application lock Writer_Source_Container_ALL 2021-07-09 11:22:33,909 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:33,909 [INFO ] Writing data for 'Group' 2021-07-09 11:22:33,909 [INFO ] SyncDeviceLocationToSite 2021-07-09 11:22:33,909 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,909 [INFO ] Writing data for 'Group' successfully processed in 0 seconds. 2021-07-09 11:22:33,909 [INFO ] Released application lock Writer_Source_Group_ALL 2021-07-09 11:22:33,909 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:33,909 [INFO ] Writing data for 'Evidence' 2021-07-09 11:22:33,909 [INFO ] CleanupConnectionEvidence 2021-07-09 11:22:33,909 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,909 [INFO ] Create instances for SAP servers 2021-07-09 11:22:33,909 [INFO ] Added 0 new instances for SAP servers 2021-07-09 11:22:33,909 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:33,909 [INFO ] WriteFileEvidence - MatchFiles 2021-07-09 11:22:34,190 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:34,206 [INFO ] Skipping step due to 'FileMatchingServiceMode' feature toggle is set to 'off' 2021-07-09 11:22:34,206 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:34,206 [INFO ] FileEvidenceSetup 2021-07-09 11:22:34,206 [INFO ] Writer step 'FileEvidenceSetup' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:34,206 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:34,206 [INFO ] Create SAP Instance Users 2021-07-09 11:22:34,253 [INFO ] Added 0 new instance users for SAP 2021-07-09 11:22:34,253 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:34,253 [INFO ] WriteFileEvidence - Load 2021-07-09 11:22:34,253 [INFO ] Writer step 'WriteFileEvidence - Load' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:48,481 [INFO ] Loaded 599325 File Evidence records 2021-07-09 11:22:48,481 [INFO ] Successfully processed in 14 seconds 2021-07-09 11:22:48,481 [INFO ] WriteFileEvidence - Match without wildcards 2021-07-09 11:22:48,481 [INFO ] Writer step 'WriteFileEvidence - Match without wildcards' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:49,138 [INFO ] Matched 126 records to existing File Evidence without wildcards 2021-07-09 11:22:49,138 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:49,138 [INFO ] WriteFileEvidence - Load wildcards 2021-07-09 11:22:49,138 [INFO ] Writer step 'WriteFileEvidence - Load wildcards' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:49,716 [INFO ] Found 10406 File Evidence records with wildcards 2021-07-09 11:22:49,716 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:49,716 [INFO ] WriteFileEvidence - Match with simple wildcards 2021-07-09 11:22:49,716 [INFO ] Writer step 'WriteFileEvidence - Match with simple wildcards' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:50,153 [INFO ] Matched 13 records to existing File Evidence with wildcards 2021-07-09 11:22:50,153 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,153 [INFO ] WriteFileEvidence - Load imported Unix evidence 2021-07-09 11:22:50,153 [INFO ] Writer step 'WriteFileEvidence - Load imported Unix evidence' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:50,169 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,169 [INFO ] WriteFileEvidence - Match with Unix wildcards 2021-07-09 11:22:50,169 [INFO ] Writer step 'WriteFileEvidence - Match with Unix wildcards' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:50,669 [INFO ] Matched 0 records to existing Unix File Evidence with wildcards 2021-07-09 11:22:50,669 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,669 [INFO ] WriteFileEvidence - Match double ended wildcards 2021-07-09 11:22:50,669 [INFO ] Writer step 'WriteFileEvidence - Match double ended wildcards' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:50,685 [INFO ] Matched 0 records to existing File Evidence with start and end wildcards 2021-07-09 11:22:50,685 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,685 [INFO ] WriteFileEvidence - MatchFilesTest 2021-07-09 11:22:50,685 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:50,700 [INFO ] Skipping step due to 'FileMatchingServiceMode' feature toggle not in 'testing' mode 2021-07-09 11:22:50,700 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,700 [INFO ] CleanupConnectionInstallerEvidence 2021-07-09 11:22:50,888 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,888 [INFO ] WriteFileEvidence - Load unmatched evidence 2021-07-09 11:22:50,903 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:50,903 [INFO ] WriteFileEvidence - Insert unmatched evidence 2021-07-09 11:22:51,075 [INFO ] Added 0 File Evidence records from the source database connections. 2021-07-09 11:22:51,075 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,075 [INFO ] WriteFileEvidence - Insert unmatched evidence mapping 2021-07-09 11:22:51,138 [INFO ] Matched 0 records to File Evidence that was just added 2021-07-09 11:22:51,138 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,138 [INFO ] WriteFileEvidence - Update local access modes 2021-07-09 11:22:51,138 [INFO ] Updated 0 imported file evidence records to a local access mode 2021-07-09 11:22:51,138 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,138 [INFO ] WriteInstalledFileEvidence 2021-07-09 11:22:51,231 [INFO ] Identified 348 installed file evidence records 2021-07-09 11:22:51,231 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,231 [INFO ] WriteVDIInstalledFileEvidence 2021-07-09 11:22:51,278 [INFO ] Generated 0 VDI installed file evidence records 2021-07-09 11:22:51,278 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,278 [INFO ] DeleteUnrequiredInstalledFileEvidence 2021-07-09 11:22:51,294 [INFO ] Identified 0 InstalledFileEvidence rows to be deleted 2021-07-09 11:22:51,294 [INFO ] Removed 0 records from InstalledFileEvidence that no longer exist in data sources 2021-07-09 11:22:51,294 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,294 [INFO ] InsertIntoInstalledFileEvidence 2021-07-09 11:22:51,294 [INFO ] Added 0 new installed file evidence records into InstalledFileEvidence 2021-07-09 11:22:51,294 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,294 [INFO ] WriteFileEvidenceMatchCounts 2021-07-09 11:22:51,356 [INFO ] Jul 9 2021 11:22AM - Deleted 0 file evidence match counts 2021-07-09 11:22:51,356 [INFO ] Jul 9 2021 11:22AM - Updated 0 file evidence match counts 2021-07-09 11:22:51,356 [INFO ] Jul 9 2021 11:22AM - Inserted 0 file evidence match counts 2021-07-09 11:22:51,356 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,356 [INFO ] WriteRemoteFileEvidenceMatchCounts 2021-07-09 11:22:51,372 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,372 [INFO ] WriteInstallerEvidence - MatchInstaller 2021-07-09 11:22:51,372 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:22:51,372 [INFO ] Skipping step due to InstallerMatchingServiceMode feature toggle is set to 'off' 2021-07-09 11:22:51,372 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,372 [INFO ] RemoveOrphanedFileEvidenceRecords 2021-07-09 11:22:51,419 [INFO ] Identified 0 NewFileEvidence records to be deleted 2021-07-09 11:22:51,419 [INFO ] Removed 0 NewFileEvidence records in NewFileEvidence table 2021-07-09 11:22:51,419 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,419 [INFO ] InstallerEvidenceSetup 2021-07-09 11:22:51,419 [INFO ] Writer step 'InstallerEvidenceSetup' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:51,856 [INFO ] Cleaned up relevant temporary working tables before further processing starts 2021-07-09 11:22:51,856 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:22:51,856 [INFO ] Product Code Setup 2021-07-09 11:22:51,856 [INFO ] Writer step 'Product Code Setup' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:22:53,341 [INFO ] Matched 0 incoming Installer Evidence records with product codes to the existing Installer Evidence without wildcards 2021-07-09 11:22:53,341 [INFO ] Matched 0 incoming Installer Evidence records with product codes to the existing Installer Evidence with wildcards 2021-07-09 11:22:53,341 [INFO ] Successfully processed in 1 second 2021-07-09 11:22:53,341 [INFO ] WriteInstallerEvidence 2021-07-09 11:22:53,341 [INFO ] Writer step 'WriteInstallerEvidence' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:24:03,882 [INFO ] Matched 1012 incoming Installer Evidence records to the existing Installer Evidence without wildcards 2021-07-09 11:24:03,882 [INFO ] Matched 22506 incoming Installer Evidence records to the existing Installer Evidence with wildcards 2021-07-09 11:24:03,882 [INFO ] Matched 0 incoming Installer Evidence records to the existing Installer Evidence with wildcards, and ignoring publisher 2021-07-09 11:24:03,882 [INFO ] Matched 0 incoming Installer Evidence records to the existing Installer Evidence with wildcards, and ignoring publisher and version 2021-07-09 11:24:03,882 [INFO ] Successfully processed in 1 minute, 10 seconds 2021-07-09 11:24:03,882 [INFO ] WriteInstallerEvidence - MatchInstallerTest 2021-07-09 11:24:03,882 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:03,882 [INFO ] Skipping step due to 'InstallerMatchingServiceMode' feature toggle not in 'testing' mode 2021-07-09 11:24:03,882 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:03,882 [INFO ] WriteInstallerEvidence - Load and Insert unmatched evidence 2021-07-09 11:24:03,991 [INFO ] Added 0 Installer Evidence records from the source database connections. 2021-07-09 11:24:03,991 [INFO ] Matched 0 newly created Installer Evidence records to the incoming Installer Evidence 2021-07-09 11:24:03,991 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:03,991 [INFO ] Remove local installer evidence linked to Flexera installer evidence 2021-07-09 11:24:04,054 [INFO ] Deleted 0 records from ImportedInstallerEvidenceMapping. 2021-07-09 11:24:04,054 [INFO ] Deleted 0 local installer evidence records that have been matched to ARL. 2021-07-09 11:24:04,054 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:04,054 [INFO ] WriteInstanceAndAttributeMapping 2021-07-09 11:24:04,069 [INFO ] Added 0 new installer evidence attributes 2021-07-09 11:24:04,069 [INFO ] Matched 69 installer evidence attributes 2021-07-09 11:24:04,069 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:04,069 [INFO ] StageImportedInstalledInstallerEvidence 2021-07-09 11:24:07,616 [INFO ] Staged 1577002 imported installed installer evidence records 2021-07-09 11:24:07,616 [INFO ] Successfully processed in 3 seconds 2021-07-09 11:24:07,616 [INFO ] CalculateInstalledInstallerEvidence 2021-07-09 11:24:09,772 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:24:09,772 [INFO ] Found 893404 installed installer evidence records 2021-07-09 11:24:09,772 [INFO ] Successfully processed in 2 seconds 2021-07-09 11:24:09,772 [INFO ] WriteRemoteAccessInstalledInstallerEvidence 2021-07-09 11:24:10,319 [INFO ] Generated 0 remote access installed installer evidence records 2021-07-09 11:24:10,319 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:10,319 [INFO ] WriteVDIInstalledInstallerEvidence 2021-07-09 11:24:10,413 [INFO ] Generated 0 VDI installed installer evidence records 2021-07-09 11:24:10,413 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:10,413 [INFO ] WriteInstalledInstallerEvidence 2021-07-09 11:24:19,585 [INFO ] Added 0 new installed installer evidence records 2021-07-09 11:24:19,585 [INFO ] Removed 0 installed installer evidence records that no longer exists from data sources 2021-07-09 11:24:19,585 [INFO ] Updated 8119 installer evidence counts for installations and computer matches 2021-07-09 11:24:19,585 [INFO ] Inserted 0 related installer evidence records 2021-07-09 11:24:19,585 [INFO ] Deleted 0 related installer evidence records 2021-07-09 11:24:19,585 [INFO ] 2021-07-09 11:24:19,585 [INFO ] Successfully processed in 9 seconds 2021-07-09 11:24:19,585 [INFO ] CopyCitrixFileEvidenceMappingToCompliance 2021-07-09 11:24:19,679 [WARN ] Warning! The maximum key length for a clustered index is 900 bytes. The index 'IX_TmpCitrixRemoteEvidenceMapping' has maximum length of 1036 bytes. For some combination of large values, the insert/update operation will fail. 2021-07-09 11:24:19,679 [INFO ] Removed 0 Citrix file evidence mapping records which no longer exist in the source 2021-07-09 11:24:19,679 [INFO ] Transferred 0 new Citrix file evidence mapping records 2021-07-09 11:24:19,679 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,679 [INFO ] WriteInstalledInstallerAttribute 2021-07-09 11:24:19,757 [INFO ] Removed 0 installed installer evidence attributes that no longer exist from the data sources 2021-07-09 11:24:19,757 [INFO ] Updated 0 installed installer evidence attribute values 2021-07-09 11:24:19,757 [INFO ] Added 0 new installed installer evidence attribute values 2021-07-09 11:24:19,757 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,757 [INFO ] WriteRemoteInstallerEvidenceMatchCounts 2021-07-09 11:24:19,788 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,788 [INFO ] Populate ComplianceComputerRuleResult 2021-07-09 11:24:19,819 [INFO ] Added 0 Compliance Computer Rule Results 2021-07-09 11:24:19,819 [INFO ] Deleted 0 Compliance Computer Rule Results 2021-07-09 11:24:19,819 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,819 [INFO ] CopyCitrixInstallerEvidenceMappingToCompliance 2021-07-09 11:24:19,850 [WARN ] Warning! The maximum key length for a clustered index is 900 bytes. The index 'IX_TmpCitrixRemoteInstallerEvidenceMapping' has maximum length of 1036 bytes. For some combination of large values, the insert/update operation will fail. 2021-07-09 11:24:19,850 [INFO ] Removed 0 Citrix installer evidence mapping records which no longer exist in the source 2021-07-09 11:24:19,850 [INFO ] Transferred 0 new Citrix installer evidence mapping records 2021-07-09 11:24:19,850 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,850 [INFO ] InstallerEvidenceCleanup 2021-07-09 11:24:19,850 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,850 [INFO ] CleanupConnectionWMIEvidence 2021-07-09 11:24:19,882 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,882 [INFO ] Write WMIEvidence - Match 2021-07-09 11:24:19,882 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:19,882 [INFO ] Skipping step due to WmiMatchingServiceMode feature toggle is set to 'off' 2021-07-09 11:24:19,882 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:19,882 [INFO ] Write WMIEvidence: Populate the ManageSoft rules to imported evidence mapping and WMIEvidence table 2021-07-09 11:24:19,882 [INFO ] Writer step 'Write WMIEvidence: Populate the ManageSoft rules to imported evidence mapping and WMIEvidence table' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:24:20,069 [INFO ] Matched 312 records to existing WMI Evidence without wildcards 2021-07-09 11:24:20,069 [INFO ] Matched 26 records to existing WMI Evidence with wildcards 2021-07-09 11:24:20,069 [INFO ] Added 0 new WMI Evidence records from the source database connections. 2021-07-09 11:24:20,069 [INFO ] Matched 0 records to WMI Evidence that was just added 2021-07-09 11:24:20,069 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:20,069 [INFO ] Write WMIEvidence - MatchTest 2021-07-09 11:24:20,069 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:20,069 [INFO ] Skipping step due to 'WmiMatchingServiceMode' feature toggle not in 'testing' mode 2021-07-09 11:24:20,069 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:20,069 [INFO ] CalculateInstalledWMIEvidence 2021-07-09 11:24:20,382 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:20,382 [INFO ] WriteInstalledWMIEvidence 2021-07-09 11:24:20,757 [INFO ] Inserted 0 new records into InstalledWMIEvidence 2021-07-09 11:24:20,757 [INFO ] Deleted 0 old records from InstalledWMIEvidence 2021-07-09 11:24:20,757 [INFO ] Updated 334 evidence installation and computer counts 2021-07-09 11:24:20,757 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:20,757 [INFO ] DeleteAgedDataFromSource 2021-07-09 11:24:20,819 [INFO ] Deleted 0 access occurrences which are older than 90 days 2021-07-09 11:24:20,819 [INFO ] Deleted 0 access evidences which has all the occurrences deleted 2021-07-09 11:24:20,819 [INFO ] Deleted 0 accessing devices which which does not have any evidences associated 2021-07-09 11:24:20,819 [INFO ] Deleted 0 accessing users which which does not have any evidences associated 2021-07-09 11:24:20,819 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:20,819 [INFO ] WriteAccessingDevice 2021-07-09 11:24:21,179 [INFO ] Added 0 accessing devices to temp table which does not appear in the imported tables 2021-07-09 11:24:21,179 [INFO ] Inserted 0 new accessing devices which did not exist before 2021-07-09 11:24:21,179 [INFO ] Updated 8368 AccessingDeviceID value in staging accessing device table 2021-07-09 11:24:21,179 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:21,179 [INFO ] MatchAccessingDevice 2021-07-09 11:24:22,663 [INFO ] Matched 6815 accessing devices with compliance computer based on computer name and external Id 2021-07-09 11:24:22,663 [INFO ] Matched 89 accessing devices with compliance computer based on computer name and domain 2021-07-09 11:24:22,663 [INFO ] Matched 0 accessing devices with compliance computer based on computer name and IP address 2021-07-09 11:24:22,663 [INFO ] Matched 0 accessing devices with compliance computer based on computer name 2021-07-09 11:24:22,663 [INFO ] Matched 0 accessing devices with compliance computer based on unique IP address 2021-07-09 11:24:22,663 [INFO ] Matched 0 accessing devices with compliance computer based on IP address and Assigned user 2021-07-09 11:24:22,663 [INFO ] Matched 0 accessing devices with compliance computer based on IP address and calculated user 2021-07-09 11:24:22,663 [INFO ] Matched 0 accessing devices with compliance computer compliance usage based on IP address and history user 2021-07-09 11:24:22,663 [INFO ] Successfully processed in 1 second 2021-07-09 11:24:22,663 [INFO ] WriteAccessingUser 2021-07-09 11:24:22,866 [INFO ] Added 0 accessing users in to temp table which does not appear in the imported tabales 2021-07-09 11:24:22,866 [INFO ] Inserted 0 new accessing users which did not exist before 2021-07-09 11:24:22,866 [INFO ] Updated 9112 AccessingUserID value in staging accessing user table 2021-07-09 11:24:22,866 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:22,866 [INFO ] MatchAccessingUser 2021-07-09 11:24:23,163 [INFO ] Matched 3958 accessing users with compliance users based on SAM account name and domain name 2021-07-09 11:24:23,163 [INFO ] Matched 0 accessing users with compliance users based on user name and domain name 2021-07-09 11:24:23,163 [INFO ] Matched 0 accessing users with compliance users based on email address 2021-07-09 11:24:23,163 [INFO ] Updated 3958 accessing users with compliance users based from temp table 2021-07-09 11:24:23,163 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:23,163 [INFO ] CleanupAccessEvidence 2021-07-09 11:24:23,163 [INFO ] Cleaned up relevant temporary working tables before further processing starts 2021-07-09 11:24:23,163 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:23,163 [INFO ] AccessEvidenceMatching - Match 2021-07-09 11:24:23,163 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:23,178 [INFO ] Skipping step due to AccessMatchingServiceMode feature toggle is set to 'off' 2021-07-09 11:24:23,178 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:23,178 [INFO ] AccessEvidenceMatching 2021-07-09 11:24:23,178 [INFO ] Writer step 'AccessEvidenceMatching' with non-default execution path (Fallback) meets condition TestingOrFallback. 2021-07-09 11:24:23,288 [INFO ] Cleaned up temporary mapping table before further processing starts 2021-07-09 11:24:23,288 [INFO ] Matched 5 incoming access evidence records to existing access evidence without wildcard match 2021-07-09 11:24:23,288 [INFO ] Matched 2 incoming access evidence records to existing access evidence with wildcard match 2021-07-09 11:24:23,288 [INFO ] Added 0 Access Evidence records from the source database connections. 2021-07-09 11:24:23,288 [INFO ] Matched 0 incoming access Evidence records with product name to new Access Evidence with display name 2021-07-09 11:24:23,288 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:23,288 [INFO ] WriteAccessedAccessEvidence - MatchTest 2021-07-09 11:24:23,288 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:23,288 [INFO ] Skipping step due to 'AccessMatchingServiceMode' feature toggle not in 'testing' mode 2021-07-09 11:24:23,288 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:23,288 [INFO ] WriteAccessedAccessEvidence 2021-07-09 11:24:26,850 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:24:26,850 [INFO ] Deleted 0 access evidence records which does not exist in the source tables 2021-07-09 11:24:26,850 [INFO ] Deleted 0 access evidence records which does not exist in the source tables 2021-07-09 11:24:26,850 [INFO ] Deleted 0 access evidence records which does not exist in the source tables 2021-07-09 11:24:26,850 [INFO ] Added 0 new access evidence records in to the accessed access evidence table 2021-07-09 11:24:26,850 [INFO ] Added 2 new match count records in to the access evidence match count table 2021-07-09 11:24:26,850 [INFO ] Successfully processed in 3 seconds 2021-07-09 11:24:26,850 [INFO ] WriteAccessedAccessEvidenceOccurrence 2021-07-09 11:24:41,022 [INFO ] Deleted 0 access occurrences which does not exist in the source table 2021-07-09 11:24:41,022 [INFO ] Updated 588729 access count of existing access records 2021-07-09 11:24:41,022 [INFO ] Added 0 new access evidence occurrences for the accessed access evidences 2021-07-09 11:24:41,022 [INFO ] Successfully processed in 14 seconds 2021-07-09 11:24:41,022 [INFO ] UpdateAccessedAccessEvidence 2021-07-09 11:24:42,413 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:24:42,413 [INFO ] Updated 0 access evidences with data from occurrences 2021-07-09 11:24:42,413 [INFO ] Successfully processed in 1 second 2021-07-09 11:24:42,413 [INFO ] WriteSoftwareTitle 2021-07-09 11:24:42,413 [INFO ] Added 0 new SoftwareTitle records 2021-07-09 11:24:42,428 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:42,428 [INFO ] WriteSoftwareTitleAccessEvidence 2021-07-09 11:24:42,428 [INFO ] Added 0 new SoftwareTitleAccessEvidence records 2021-07-09 11:24:42,428 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:42,428 [INFO ] Writing data for 'Evidence' successfully processed in 2 minutes, 8 seconds. 2021-07-09 11:24:42,428 [INFO ] Released application lock Writer_Source_Evidence_ALL 2021-07-09 11:24:42,428 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:42,428 [INFO ] Writing data for 'MatchARL' 2021-07-09 11:24:42,428 [INFO ] Create SAP Applications 2021-07-09 11:24:44,022 [INFO ] Added 0 new SAP application installation records 2021-07-09 11:24:44,022 [INFO ] Successfully processed in 1 second 2021-07-09 11:24:44,022 [INFO ] AutoLinkUnassignedRepackageInstallerEvidenceToItsOriginalApplication 2021-07-09 11:24:44,178 [INFO ] Identified 1 current installer evidence (AdminStudio repackaged) that are not assigned to any applications 2021-07-09 11:24:44,178 [INFO ] Identified 0 current installer evidence (AdminStudio repackaged) that are not assigned to any applications 2021-07-09 11:24:44,178 [INFO ] Automatically assigned 0 current installer evidence (AdminStudio repackaged) to their original applications 2021-07-09 11:24:44,178 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:44,178 [INFO ] ApplicationsByWMIEvidence 2021-07-09 11:24:44,366 [INFO ] Found 0 Application installations from WMI evidence that are also recognized by installer evidence 2021-07-09 11:24:44,366 [INFO ] Found 5268 Application installations from WMI evidence 2021-07-09 11:24:44,366 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:44,366 [INFO ] ApplicationsByInstallerEvidence 2021-07-09 11:24:49,119 [INFO ] Found 180 Application installations from Installer evidence that are also recognized by SAP evidence 2021-07-09 11:24:49,119 [INFO ] Found 143155 Application installations from Installer evidence 2021-07-09 11:24:49,119 [INFO ] Found 0 related application installations from Installer evidence 2021-07-09 11:24:49,119 [INFO ] Deleted 0 related application installations from Installer evidence 2021-07-09 11:24:49,119 [INFO ] Inserted 0 related application installations from Installer evidence 2021-07-09 11:24:49,119 [INFO ] Successfully processed in 4 seconds 2021-07-09 11:24:49,119 [INFO ] ApplicationsByFileEvidence 2021-07-09 11:24:49,494 [INFO ] Found 197 Application installations from file evidence that are also recognized by installer or WMI evidence 2021-07-09 11:24:49,494 [INFO ] Found 8 Application installations from file evidence 2021-07-09 11:24:49,494 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:49,494 [INFO ] RemoteApplicationsByFileEvidenceTempTables 2021-07-09 11:24:49,588 [INFO ] Found 0 remote file usage records 2021-07-09 11:24:49,604 [INFO ] Found 0 remote file user access records 2021-07-09 11:24:49,604 [INFO ] Found 0 remote server file evidence from VDI data 2021-07-09 11:24:49,604 [INFO ] Found 0 remote application access records based on remote file and server data 2021-07-09 11:24:49,604 [INFO ] Found 0 remote application access records based on remote file and VDI Group UUID data 2021-07-09 11:24:49,604 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:49,604 [INFO ] RemoteApplicationsByFileEvidenceUsage 2021-07-09 11:24:49,885 [INFO ] Found 0 file usage based installation records that matched a server application 2021-07-09 11:24:49,885 [INFO ] Found 0 file usage based installations records that did not match a server application 2021-07-09 11:24:49,885 [INFO ] Found 0 Application installations (remotely accessed) based on file evidence usage for remotely accessed applications 2021-07-09 11:24:49,885 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:49,885 [INFO ] RemoteApplicationsByFileEvidence 2021-07-09 11:24:50,072 [INFO ] Found 0 application from remote server file evidence based on remote ACL file access. 2021-07-09 11:24:50,072 [INFO ] Found 0 application from remote server file evidence based on remote ACL file access. 2021-07-09 11:24:50,072 [INFO ] Found 0 applications that did not match any applications on the remote server. 2021-07-09 11:24:50,072 [INFO ] Found 0 Application installations (remotely accessed) based on file evidence and on user Access Control List (ACL) for remotely accessed applications 2021-07-09 11:24:50,072 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:50,072 [INFO ] ApplicationsRequiringStrictMatching 2021-07-09 11:24:51,057 [INFO ] Found 1 Application installations from wmi evidence (strict matching) that are also recognized by installer or WMI evidence 2021-07-09 11:24:51,057 [INFO ] Found 48 Application installations from wmi evidence (strict matching) 2021-07-09 11:24:51,057 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:51,057 [INFO ] RecalculateInstalledApplicationsForRemoteACLDevices 2021-07-09 11:24:51,166 [INFO ] Removed 0 remotely accessed application installations to be pushed into existing installations to avoid double counting 2021-07-09 11:24:51,166 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:51,166 [INFO ] Instances 2021-07-09 11:24:51,182 [INFO ] Found 0 installed Instance applications 2021-07-09 11:24:51,182 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:51,182 [INFO ] ApplicationRemovalByPrecedence 2021-07-09 11:24:51,369 [INFO ] Removed 102 application installations in favor of higher quality applications, using precedence rules 2021-07-09 11:24:51,369 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:51,369 [INFO ] ApplicationReplacementBySuites 2021-07-09 11:24:51,900 [INFO ] Found 7 installed application suites having their own installer or file evidence 2021-07-09 11:24:51,900 [INFO ] Removed 7 installed application records where their corresponding application suites already have installation records 2021-07-09 11:24:51,900 [INFO ] Found 702 installed application suites based on their Mandatory and Mininumn Number of Apps criteria 2021-07-09 11:24:51,900 [INFO ] Removed 702 installed application records to be replaced by their application suites 2021-07-09 11:24:51,900 [INFO ] Added 133 installed application suites as replacement for their removed application members 2021-07-09 11:24:51,900 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:51,900 [INFO ] ApplicationReplacementBySuitesForInstances 2021-07-09 11:24:51,916 [INFO ] Removed 0 installed Instance applications to be replaced by their application suites 2021-07-09 11:24:51,916 [INFO ] Added 0 installed application suite Instances as replacement for their removed application members 2021-07-09 11:24:51,916 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:51,916 [INFO ] ApplicationDeletion 2021-07-09 11:24:52,636 [INFO ] Removed 0 allocation records for instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Removed 1 instance history records for instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Removed 0 instance users for instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Removed 0 instance attributes for instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Removed 0 Oracle instances for instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Unassigned 1 instances from their parent instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Unassigned 0 instances from their manager instances which are about to be deleted 2021-07-09 11:24:52,636 [INFO ] Removed 1 Installed Application Instances that no longer exist in source database connections. 2021-07-09 11:24:52,636 [INFO ] Removed 0 Installed Applications that no longer exist in source database connections. 2021-07-09 11:24:52,636 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:52,636 [INFO ] ApplicationCompletion 2021-07-09 11:24:54,933 [INFO ] Updated 0 Installed Applications that have changed in the source database connections. 2021-07-09 11:24:54,933 [INFO ] Added 0 new Installed Applications from the source database connections. 2021-07-09 11:24:54,933 [INFO ] Inserted 0 related installed software records 2021-07-09 11:24:54,933 [INFO ] Updated 0 application record actions 2021-07-09 11:24:54,933 [INFO ] Successfully processed in 2 seconds 2021-07-09 11:24:54,933 [INFO ] VMHostsManagedBySoftwareRelationships 2021-07-09 11:24:55,011 [INFO ] Deleted 0 VM hosts managed by software relationships 2021-07-09 11:24:55,011 [INFO ] Inserted 0 VM hosts managed by software relationships 2021-07-09 11:24:55,011 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,011 [INFO ] ApplicationInstancesTempTables 2021-07-09 11:24:55,027 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,027 [INFO ] ApplicationInstances 2021-07-09 11:24:55,277 [INFO ] Added 0 new Installed Application Instances from the source database connections. 2021-07-09 11:24:55,277 [INFO ] Found 0 applications with instance mappings 2021-07-09 11:24:55,277 [INFO ] Found 0 oracle instance mappings 2021-07-09 11:24:55,277 [INFO ] Found 0 Oracle EBS instance mappings 2021-07-09 11:24:55,277 [INFO ] Assigned 0 Oracle application instances to their parent application instances 2021-07-09 11:24:55,277 [INFO ] Assigned 0 Oracle EBS application records to their parent application instances 2021-07-09 11:24:55,277 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,277 [INFO ] SoftwareSuiteCompletion 2021-07-09 11:24:55,339 [INFO ] Kept 0 application installation records what where replaced by their application suites, for record keeping purposes 2021-07-09 11:24:55,339 [INFO ] Kept 0 application Instance installation records what where replaced by their application suites, for record keeping purposes 2021-07-09 11:24:55,339 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,339 [INFO ] ApplicationAttributes 2021-07-09 11:24:55,417 [INFO ] Removed 0 existing installed application instance attribute values 2021-07-09 11:24:55,417 [INFO ] Updated 0 installed application instance attribute values 2021-07-09 11:24:55,417 [INFO ] Added 0 new installed application instance attribute values 2021-07-09 11:24:55,417 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,417 [INFO ] InstalledSoftwareAttributes 2021-07-09 11:24:55,464 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,464 [INFO ] ApplicationInstanceUsers 2021-07-09 11:24:55,808 [INFO ] Removed 0 existing instance users 2021-07-09 11:24:55,808 [INFO ] Added 0 new Oracle application instance users 2021-07-09 11:24:55,808 [INFO ] Added 0 new EBS application instance users 2021-07-09 11:24:55,808 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:55,808 [INFO ] ArchiveOracleLMSAuditEvidence 2021-07-09 11:24:56,167 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:24:56,402 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:24:56,402 [INFO ] ApplicationAlerts 2021-07-09 11:26:10,800 [INFO ] Successfully processed in 1 minute, 14 seconds 2021-07-09 11:26:10,800 [INFO ] EvidenceAlerts 2021-07-09 11:27:09,175 [INFO ] Successfully processed in 58 seconds 2021-07-09 11:27:09,175 [INFO ] InstalledSoftwareAlerts 2021-07-09 11:27:09,222 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,222 [INFO ] Clean Up TemporalInstalledSoftware 2021-07-09 11:27:09,222 [INFO ] TemporalInstalledSoftware clean up deleted 0 records that were closed over 180 days ago. 2021-07-09 11:27:09,222 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,222 [INFO ] Populate TemporalInstalledSoftware 2021-07-09 11:27:09,238 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,238 [INFO ] CompileOracleOptionUsageEvidence 2021-07-09 11:27:09,253 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,253 [INFO ] DeleteAccessedSoftware 2021-07-09 11:27:09,269 [INFO ] Deleted 0 accessed software records which do not have a valid accessing user 2021-07-09 11:27:09,269 [INFO ] Deleted 0 accessed software records which do not have a valid accessing device 2021-07-09 11:27:09,269 [INFO ] Deleted 0 accessing devices which does not exist in the source 2021-07-09 11:27:09,269 [INFO ] Deleted 0 accessing users which does not exist in the source 2021-07-09 11:27:09,269 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,269 [INFO ] WriteAccessedSoftware 2021-07-09 11:27:09,300 [INFO ] Inserted 2 new accessed software records 2021-07-09 11:27:09,300 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,300 [INFO ] WriteAccessedSoftwareOccurrence 2021-07-09 11:27:09,347 [INFO ] Deleted 0 accessed software occurrence which does not exist in source 2021-07-09 11:27:09,347 [INFO ] Deleted 2 accessed software records which has all the occurrences removed 2021-07-09 11:27:09,347 [INFO ] Updated 0 AccessCount of accessed software occurrence records for existing accessed softwares 2021-07-09 11:27:09,347 [INFO ] Inserted 0 new accessed software occurrence records 2021-07-09 11:27:09,347 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,347 [INFO ] UpdateAccessedSoftware 2021-07-09 11:27:09,347 [INFO ] Updated 0 accessed softwares with data from occurrences 2021-07-09 11:27:09,347 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,347 [INFO ] Writing data for 'MatchARL' successfully processed in 2 minutes, 26 seconds. 2021-07-09 11:27:09,347 [INFO ] Released application lock Writer_Source_MatchARL_ALL 2021-07-09 11:27:09,347 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:09,347 [INFO ] Writing data for 'Usage' 2021-07-09 11:27:09,347 [INFO ] CreateTempInstalledSoftwareUsageTable 2021-07-09 11:27:09,675 [INFO ] Created various temporary working tables needed for succeeding operations 2021-07-09 11:27:09,675 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,675 [INFO ] InsertInstalledSoftwareFlatList 2021-07-09 11:27:09,941 [INFO ] Found 147801 installed software records 2021-07-09 11:27:09,941 [INFO ] Found 709 installed software records that were replaced by suites 2021-07-09 11:27:09,941 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:09,941 [INFO ] InsertComputerEvidenceFromFileEvidenceUsage 2021-07-09 11:27:10,566 [INFO ] Found 63 computer evidence records from file evidence usage 2021-07-09 11:27:10,566 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:10,566 [INFO ] InsertComputerEvidenceFromInstallerEvidenceUsage 2021-07-09 11:27:11,909 [INFO ] Found 26215 computer evidence records from installer evidence usage 2021-07-09 11:27:11,909 [INFO ] Successfully processed in 1 second 2021-07-09 11:27:11,909 [INFO ] InsertComputerEvidenceFromImportedRemoteUserToApplicationAccess 2021-07-09 11:27:11,925 [INFO ] Found 0 computer evidence records from Office 365 usage 2021-07-09 11:27:11,925 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:11,925 [INFO ] InsertIntoTempInstalledSoftwareUsage 2021-07-09 11:27:11,956 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:11,956 [INFO ] InsertUsageDetails 2021-07-09 11:27:12,050 [INFO ] Found 26136 usage detail records 2021-07-09 11:27:12,050 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,050 [INFO ] InsertUsageDetailsFromRemoteApplicationUsage 2021-07-09 11:27:12,081 [INFO ] Found 0 usage detail records from remote application usage 2021-07-09 11:27:12,081 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,081 [INFO ] CreateUsageDetailsIndex 2021-07-09 11:27:12,113 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,113 [INFO ] InsertInstalledSoftwareUsageTemp 2021-07-09 11:27:12,238 [INFO ] Found 25972 installed application usage records 2021-07-09 11:27:12,238 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,238 [INFO ] InsertIntoTempInstanceUsage 2021-07-09 11:27:12,253 [INFO ] Found 0 installed instance application usage records 2021-07-09 11:27:12,253 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,253 [INFO ] RemoveInstalledSoftwareUsage 2021-07-09 11:27:12,378 [INFO ] Removed 0 Usage records that no longer exist in source database connections. 2021-07-09 11:27:12,378 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,378 [INFO ] UpdateInstalledSoftwareUsage 2021-07-09 11:27:12,472 [INFO ] Updated 0 Usage records that have changed in the source database connections. 2021-07-09 11:27:12,472 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,472 [INFO ] InsertInstalledSoftwareUsage 2021-07-09 11:27:12,722 [INFO ] Added 0 new Usage records from the source database connections. 2021-07-09 11:27:12,722 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:12,722 [INFO ] UpdateApplicationUsage 2021-07-09 11:27:13,894 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:27:13,894 [INFO ] Marked 0 installed application records having usage data 2021-07-09 11:27:13,894 [INFO ] Marked 17152 installed application records with last used date 2021-07-09 11:27:13,894 [INFO ] Marked 0 installed instance applications having usage data 2021-07-09 11:27:13,894 [INFO ] Successfully processed in 1 second 2021-07-09 11:27:13,894 [INFO ] InsertSoftwareAccessModes 2021-07-09 11:27:15,831 [INFO ] Found 147801 software access modes 2021-07-09 11:27:15,831 [INFO ] Ignored 147801 software access modes that were only accessed locally 2021-07-09 11:27:15,831 [INFO ] Removed 0 obsolete software access modes 2021-07-09 11:27:15,831 [INFO ] Added 0 access modes for installed applications 2021-07-09 11:27:15,831 [INFO ] Successfully processed in 1 second 2021-07-09 11:27:15,831 [INFO ] Writing data for 'Usage' successfully processed in 6 seconds. 2021-07-09 11:27:15,847 [INFO ] Released application lock Writer_Source_Usage_ALL 2021-07-09 11:27:15,847 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:15,847 [INFO ] Writing data for 'RemoveMissingComputers' 2021-07-09 11:27:15,847 [INFO ] GetAdditionalApplicationLocks 2021-07-09 11:27:15,847 [INFO ] Created additional application lock Writer_Source_AdditionalApplicationLock_ALL 2021-07-09 11:27:15,847 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:15,847 [INFO ] CreateTmpMissingComputers 2021-07-09 11:27:15,862 [INFO ] Found 116 existing computers that no longer exist from data sources 2021-07-09 11:27:15,862 [INFO ] Found 0 existing computers that will be archived 2021-07-09 11:27:15,862 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:15,862 [INFO ] UpdateComputersAwaitingInventory 2021-07-09 11:27:16,019 [INFO ] Found 0 existing computers that no longer exists from data sources 2021-07-09 11:27:16,019 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:16,019 [INFO ] RemoveMissingComputersAndAssociatedProperties 2021-07-09 11:27:16,238 [INFO ] Retained 0 computers as virtual machines 2021-07-09 11:27:16,238 [INFO ] Removed 0 Computers that no longer exist in source database connections. 2021-07-09 11:27:16,238 [INFO ] Removed 0 ContainerImage records as the host or image computer no longer exists. 2021-07-09 11:27:16,238 [INFO ] Removed 0 ComplianceComputer records for container images which are no longer installed. 2021-07-09 11:27:16,238 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:16,238 [INFO ] ReleaseAdditionalApplicationLocks 2021-07-09 11:27:16,238 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:16,238 [INFO ] Writing data for 'RemoveMissingComputers' successfully processed in 0 seconds. 2021-07-09 11:27:16,238 [INFO ] Released application lock Writer_Source_RemoveMissingComputers_ALL 2021-07-09 11:27:16,238 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:16,238 [INFO ] Writing data for 'RemoveMissingUsers' 2021-07-09 11:27:16,238 [INFO ] RemoveMissingUsers 2021-07-09 11:27:16,362 [INFO ] Removed 0 Users that no longer exist in source database connections. 2021-07-09 11:27:16,362 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:16,362 [INFO ] Writing data for 'RemoveMissingUsers' successfully processed in 0 seconds. 2021-07-09 11:27:16,362 [INFO ] Released application lock Writer_Source_RemoveMissingUsers_ALL 2021-07-09 11:27:16,362 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:16,362 [INFO ] Writing data for 'SyncDiscoveredDevice' 2021-07-09 11:27:16,362 [INFO ] LinkComputerToDiscoveredDevice 2021-07-09 11:27:16,550 [INFO ] Unlinked 0 discovered devices from deleted compliance computers. 2021-07-09 11:27:16,550 [INFO ] Reset 5208 discovered devices links to compliance computer. 2021-07-09 11:27:16,550 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:16,550 [INFO ] CreateDiscoveredDevicesFromInventory 2021-07-09 11:27:19,941 [INFO ] Reading device information from inventory. 2021-07-09 11:27:19,941 [INFO ] Found 5208 computers which are qualified as discovered device. 2021-07-09 11:27:19,941 [INFO ] Found 194 discovered devices that no longer exist in inventory. 2021-07-09 11:27:19,941 [INFO ] Removed 0 DiscoveredDeviceParent records for computers that no longer exist. 2021-07-09 11:27:19,941 [INFO ] Removed 0 KnownOracleService records for computers that no longer exist. 2021-07-09 11:27:19,941 [INFO ] Removed 194 DiscoveredDevice records for computers that no longer exist. 2021-07-09 11:27:19,941 [INFO ] Created 0 DiscoveredDeviceParent records for virtual machines and their hosts. 2021-07-09 11:27:19,941 [INFO ] Removed 0 incoming devices because of duplicate mac addresses. 2021-07-09 11:27:19,941 [WARN ] Warning: Null value is eliminated by an aggregate or other SET operation. 2021-07-09 11:27:19,941 [INFO ] Successfully processed in 3 seconds 2021-07-09 11:27:19,941 [INFO ] UpdateDiscoveredDeviceIsManaged 2021-07-09 11:27:20,128 [INFO ] IsManagedObsoletePeriod is set to 30 2021-07-09 11:27:20,128 [INFO ] Set IsManaged to 1 for 0 discovered device(s). 2021-07-09 11:27:20,128 [INFO ] Set IsManaged to 0 for 5218 discovered device(s). 2021-07-09 11:27:20,128 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:20,128 [INFO ] Writing data for 'SyncDiscoveredDevice' successfully processed in 3 seconds. 2021-07-09 11:27:20,128 [INFO ] Released application lock Writer_Source_SyncDiscoveredDevice_ALL 2021-07-09 11:27:20,128 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:20,128 [INFO ] Writing data for 'Technopedia' 2021-07-09 11:27:20,128 [INFO ] Delete Technopedia releases without connection 2021-07-09 11:27:20,128 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:20,128 [INFO ] Create temporary tables for technopedia releases and distinct releases 2021-07-09 11:27:20,128 [INFO ] Successfully processed in 0 seconds 2021-07-09 11:27:20,128 [INFO ] Populate temporary table from imported Technopedia releases 2021-07-09 11:27:20,144 [INFO ] Failed to execute Writer 'Populate temporary table from imported Technopedia releases' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\Technopedia.xml, at step line 1 Error: Invalid object name 'dbo.importedtechnopediaarlmappedproduct'. 2021-07-09 11:27:20,144 [INFO ] All retries have been attempted for Writer 'Populate temporary table from imported Technopedia releases' 2021-07-09 11:27:20,144 [ERROR] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.importedtechnopediaarlmappedproduct'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ManageSoft.Compliance.Importer.Logic.XML.Writer.Execute(IExecutionContext context) at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteWriters(ComplianceReader p_ComplianceReader, IExecutionContext context, String singleConnectionIdentifier) ClientConnectionId:b3b63d7f-6890-4f84-bcbd-3429634e8385 Error Number:208,State:1,Class:16 2021-07-09 11:27:20,284 [DEBUG] Update the step with execution ID: 37825, EventTypeID: 188, StepID: 30, EventID: 860785, SessionUID: f40d2b53-5595-4ed4-a91f-20733b3c5aaa 2021-07-09 11:27:20,378 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config 2021-07-09 11:27:20,378 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:20,472 [INFO ] Completed with error in 0 seconds 2021-07-09 11:27:20,487 [INFO ] Released application lock Writer_Source_Technopedia_ALL 2021-07-09 11:27:20,487 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:20,487 [DEBUG] Connection string for tenantUID= type=FNMP: 'Server=CMNG-SYS1;Database=FNMScompliance;Trusted_Connection=yes;' 2021-07-09 11:27:20,487 [INFO ] Released application lock ManageSoftComplianceImporter_Exclusive 2021-07-09 11:27:20,691 [INFO ] Time: fredag 9. juli 2021 11.27.20 2021-07-09 11:27:20,691 [INFO ] Total import time: 5 minutes, 30 seconds 2021-07-09 11:27:20,691 [INFO ] 17 source data warnings 2021-07-09 11:27:20,691 [INFO ] 1 errors, 0 warnings 2021-07-09 11:27:20,691 [DEBUG] Loaded configuration from C:\ProgramData\Flexera Software\Compliance\Logging\ComplianceReader.config