Even this first topic forum reference doesn't have...

I've tested it all to see its effects on our db.

For the rare cases where we still use native backups, we use backup devices for simplicity of the commands.

Actual filenames...

That's why Testing is a must!

Thank you for the remark.

I'll remove it from my signature.

Strange indeed.

Did you replay it ( e.g.using the free PlanExplorer  )

Test  ( disregard )

Indeed.

Fingers crossed

without a doubt: "The Bare Necessities (from The Jungle Book)"

altough not a best practice, dynamic sql will be about the only way to help you out

ref: dos-and-donts-of-dynamic-sql 

btw: Where is the where clause of your query ?

Export csv and move to central share to be picked up by central inventory server.

We only monitor specific instances ( 100+ instances )

General /find on our network would cause management...

We export this data to a central file location and then have our central inventory server pickup and process those files.

SELECT SERVERPROPERTY('ServerName') AS [ServerName]
   ...

ah, that is indeed how I run most of my Posh scripts with sqlagent.

Keep in mind a unique constraint is materialized as a unique index.

You'll need to contact your devs and get their accord.

Don't just disable/drop without consent

Nice one 🙂