Custom Property to auto populate another Custom Property?

You *could* create an alert that triggers when a node is added that populates the custom property...depending on what you are trying to do and the logic/values to populate with.  you mentioned one CP causing another to update, that could be an escalation trigger action.

Personally, I have a SQL "housekeeping" job that runs and populates stuff like this.  That would be another option if you have resources with SQL skills that can help.

njoylif​ thanks for that information i will propose the the first one to my manager and i cant help but want to know what the SQL looks like would you be kind enough to share?, i did think maybe create a CASE statement when one CP is X then change Y and so on.

i am relevantly new to SQL but not backing down from it

sure...SQL knowledge will allow you to unlock a whole other level of potential within SW. 

***** DISCLAIMERS::: this is not supported by SW.

***** ALWAYS test work in a sandbox, not your production DB...and always backup your DB prior to work.  and there are tons of ways to do most everything...

Update ncp

SET custompropertyA='valueA'

FROM NodeDetails nd

  join NodeCustomProperties ncp ON (nd.nodeid=ncp.nodeid)

WHERE

     nd.machinetype='windows'

you are correct in you could use a case statement for the logic part...*** all of this is off top of my head so syntax may not be just right...google is good.

update ncp

SET custompropertyZ=CASE

     WHEN custompropertyA='ValueA' THEN 'Z'

     WHEN custompropertyA IS NULL THEN 'not Windows'

     ELSE 'something odd has happened'

     END

FROM NodeCustomProperties ncp

Awesome cheers dude, really appreciate your time and knowledge  

Dan

happy to help...that's part of what makes Thwack awesome!  Glad you found it useful