Some users may be experiencing issues when trying to access customer resources like the Case Portal or the Product Licensing Center. Our team is aware of the issue and is working to resolve it. Click here for more information.
Hi
today I noticed that I have a lot of these entries for one inventroy device:
---------------------------------------------------------------------------------------------------------------------------------------------------
19.09.2019 06:47:07 DOMAIN\FLEXADM Inventory device name was changed from Server_02 to Server_01
19.09.2019 06:47:07 DOMAIN\FLEXADM IP Address was changed from 10.10.10.2 to 10.10.10.1
19.09.2019 03:48:12 DOMAIN\FLEXADM Inventory device name was changed from Server_01 to Server_02
19.09.2019 03:48:12 DOMAIN\FLEXADM IP Address was changed from 10.10.10.1 to 10.10.10.2
---------------------------------------------------------------------------------------------------------------------------------------------------
I checked the log of the IIS and saw that both server were sending a NDI.GZ file with:
---------------------------------------------------------------------------------------------------------------------------------------------------
<Hardware Class="Win32_ComputerSystemProduct" Name="VMware Virtual Platform" Evidence="WMI">
<Property Name="IdentifyingNumber" Value="VMware-42 43 44 45 46 47 48 49"/>
<Property Name="Name" Value="VMware Virtual Platform"/>
<Property Name="UUID" Value="ABCDF-123456789-A1B2C3"/>
<Property Name="Vendor" Value="VMware, Inc."/>
<Property Name="Version" Value="None"/>
</Hardware>
---------------------------------------------------------------------------------------------------------------------------------------------------
Both server has the same IdentifyingNumber and UUID. I know that is not correct and I can ask the OS team.
But "How can I noticed, when an inventory device name was changed"?
I don't like to open 1000 server to check the history.
The alert "Alert is Serial number is not unique" show nothing, is there a report or SQL query find that out?
Regards
‎Sep 19, 2019 10:10 AM
I would recommend you to follow the guidelines outlined in the 'Duplicate serial numbers' section (beginning page 169) in https://helpnet.flexerasoftware.com/fnms/EN/WebHelp/PDF%20Documents/Cloud/GatheringFlexNetInventory.pdf
Thanks,
‎Oct 04, 2019 07:52 AM
@John
Thank you. I checked also the document.
1) The alert with the filter "Serial number is not unique"
shows no devices with the name of the server.
2) In the inventory database the numeric ComputerID for Server_01 and Server_02 is not the same.
My expectation was that the alert would show me these device(s) with the filter "Serial number is not unique" .
For me it's ok now and will use the query.
‎Oct 07, 2019 09:39 AM - edited ‎Oct 07, 2019 09:40 AM
Hi.
As you have access to the database, I would recommend access the audit tables with a query (ideally filtered for a specific subset of results on device changes as the table can be rather large.)
Attached you will find a example of such a query - SAM Objects Historical changes
‎Oct 04, 2019 10:24 AM
@Nico_Erasmus
Thanks a lot for your help.
Your post and a little bit of testing in the database shows that this query is the solution what I need.
SELECT TOP 1000 [ComplianceHistoryID]
,[ComplianceComputerID]
,[ComplianceHistoryTypeID]
,[FieldName]
,[OldValue]
,[NewValue]
,[UserName]
,[HistoryDate]
,[Comments]
,[TenantID]
FROM [FNMSCompliance].[dbo].[ComplianceHistory_MT]
WHERE [TenantID] = '3' and
[ComplianceHistoryTypeID] ='3' and
[FieldName] = 'ComputerName' and
[OldValue] <> [NewValue]
Now I found also devices as [OldValue] which are disappeared.
‎Oct 07, 2019 09:21 AM
User | Count |
---|---|
8 | |
6 | |
3 | |
3 |