Is it possible to find all published workbenches that are using a specific database connection? Nothing is obvious in the UI of FME Server.
I've managed to find fme_nc_namedconnections but I've yet to make the jump so i can see connections either in an automation or schedule or details of a workbench.
Any help gratefully received......
There's not going to be an easy way I'm afraid...
If you have access to the file system where the repositories are stored you can set up a workspace using a Workspace reader to read all your .fmw files, then check the ReaderProperties and WriterProperties for you database connection names (they'll be in the Dataset parameter)
You'll also have to account for transformers using database connections.
Alternatively, using a Text File reader, set to read the whole file at once, and then using a StringSearcher to look for the database connection names could work too.
I know @lars_de_vries has been working on a workspace-documenting-workspace, maybe he can offer some more advice.
You also need to consider whether you are just interested in finding out which workspaces use a particular named connection or whether you are wanting to find out which workspaces connect to a particular database/service whether named or embedded