Hello -
It would be very nice if when adding a node I could select another node to copy custom properties from. We have about 10 different properties we apply to each node in the datacenters, and well, people like to make typos.
Possible?
Hello -
It would be very nice if when adding a node I could select another node to copy custom properties from. We have about 10 different properties we apply to each node in the datacenters, and well, people like to make typos.
Possible?
ed_gpc, have you tried this with the web custom property editor? It's what I've been doing. I don't see any reason that wouldn't work for you. I just sanity checked with my web custom property editor. You can copy/paste as many cells as you want.
Perhaps developers could add a helpful link on the page one sees when editing a node...something like 'have many similar custom properties on another node and want to copy them? Head to Custom Property Editor" with a link on that text.
I did something that sorta accomplishes this. You can put the custom properties in a group and copy them from the group to the nodes within the group using a scheduled SQL query.
In my organization we designate a "SiteID" to represent a physical location. I have a group created for every SiteID, containing the nodes at that location. In cases where the group name is the same as the group's SiteID, this query copies some custom properties from the group to the nodes within the group. You could remove that check or add something like a yes/no field to flag when the group's properties should be applied to the group members.. I have this query running as a scheduled task using sqlcmd.exe
Update NodesCustomProperties SET
NodesCustomProperties.City = ContainerCustomProperties.City,
NodesCustomProperties.State = ContainerCustomProperties.State,
NodesCustomProperties.Country = ContainerCustomProperties.Country,
NodesCustomProperties.Address = ContainerCustomProperties.Address,
NodesCustomProperties.Company = ContainerCustomProperties.Company,
NodesCustomProperties.SiteID = ContainerCustomProperties.SiteID
from NodesCustomProperties INNER JOIN ContainerMemberDefinitions on
(right(ContainerMemberDefinitions.Expression, len(ContainerMemberDefinitions.Expression) - charindex('=',ContainerMemberDefinitions.Expression))) = NodesCustomProperties.NodeID
INNER JOIN ContainerCustomProperties on (ContainerCustomProperties.ContainerID = ContainerMemberDefinitions.ContainerID)
INNER JOIN Containers on (ContainerCustomProperties.ContainerID = Containers.ContainerID)
WHERE ContainerCustomProperties.SiteID = Containers.Name
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.