You can use Microsoft Excel to update multiple objects in Configuration Manager.
To copy and paste data to the object grid:
-
Open Microsoft Excel, and type the following in the first column of a file (you can continue with additional properties in the rows below D1):
Excel Cell
Value
A1
OUID
B1
Property Name 1 (replace with actual property name)
C1
Property Name 2 (replace with actual property name)
D1
Property Name 3 (replace with actual property name)
-
Fill in the desired values for each row with the desired values.
-
Select the populated cells from Row 1 to Row n and copy it (Ctrl+C).
-
Open Configuration Manager on the Integrity server. To open Configuration Manager, run the following file:
InstallPath\DataCollector\ConfigurationManager.exe
-
In the Asset field, click CyberIntegrity.
-
In the Object Type field, click the object type you want to change.
-
On the Object Grid tab, click the Paste button and everything will be replaced with the data from Microsoft Excel cells you copied.
-
Click Save. The information is saved to the database.