This might be handy for some of you!
Procedure:
1) Close Solarwinds Cirrus.
2) Load up the Solarwinds Database manager (Start, Programs, Solarwinds Configuration Management, Solawrinds Database Manager)
3) Left-click on the SQL servers list.
Authenticate to SQL Server if neccessary.
4) Navigate to the Cirrus database in this list. Double-click on it. Click on the "Tables" tab under SQLSERVER\\Cirrus
5) Right-click somewhere on this screen, and press "Query Table"
6) You should see some text, "Select Top * from Table". Delete this.
7) Input the SQL query included below.
8) Press Refresh.
9) Verify Results. You're done!
Synchronization Requirements:
- FQDN "Node Name" must be the same on Solarwinds Orion and Cirrus. This will work for both SNMP and non-SNMP enabled hosts.
- Device must exist in Cirrus.
Feel free to add/remove custom properties from this SQL Query.
I've opted to have solarwinds Orion be my master custom property object holder over Cirrus, so this only works Solarwinds Orion->Solarwinds Cirrus.
update Cirrus.dbo.Nodes
set Cirrus.dbo.Nodes.City = NetPerfMon.dbo.Nodes.City,
Cirrus.dbo.Nodes.Country = NetPerfMon.dbo.Nodes.Country,
Cirrus.dbo.Nodes.Building = NetPerfMon.dbo.Nodes.Building,
Cirrus.dbo.Nodes.StreetAddress = NetPerfMon.dbo.Nodes.StreetAddress,
Cirrus.dbo.Nodes.Floor = NetPerfMon.dbo.Nodes.Floor,
Cirrus.dbo.Nodes.Rack = NetPerfMon.dbo.Nodes.Rack,
Cirrus.dbo.Nodes.PostalCode = NetPerfMon.dbo.Nodes.PostalCode,
Cirrus.dbo.Nodes.LogicalDescription = NetPerfMon.dbo.Nodes.LogicalDescription,
Cirrus.dbo.Nodes.Room = NetPerfMon.dbo.Nodes.Room,
Cirrus.dbo.Nodes.Province = NetPerfMon.dbo.Nodes.Province,
Cirrus.dbo.Nodes.Unit = NetPerfMon.dbo.Nodes.Unit
FROM NetPerfMon.dbo.Nodes
WHERE NetPerfMon.dbo.Nodes.Caption COLLATE DATABASE_DEFAULT = Cirrus.dbo.Nodes.SysName COLLATE DATABASE_DEFAULT
OR NetPerfMon.dbo.Nodes.Caption COLLATE DATABASE_DEFAULT = Cirrus.dbo.Nodes.NodeCaption COLLATE DATABASE_DEFAULT
