The most recent content from our members.
We've had a SQL job for a long time now that does this job. I'd like to do this instead via SWQL, and not sure how to write it. Here is the SQL job. It basically forces Caption to equal the FQDN stripped down to the Hostname: Update NodesData SET Caption = LEFT(DNS, CHARINDEX('.', DNS) - 1) WHERE CHARINDEX('.', DNS) > 0…
It looks like you're new here. Sign in or register to get started.