I've tried adding the .SQL query files in the archive package, but still the query is not getting copied, any ideas here or should I do it seperately for each and every server?
the sqlserver probe does a md5 check on the sqlfile when you test.
This is a security precaution to make sure the the file is not tampered with.
You can create a package to install them but you will need to go in test them on each server to create the MD5 check
so that it will execute them.
I have not found or heard of a way around this as of yet.
Hello Jaya, can you please give more details about your use case. You want to add the configuration (sql queries) of a configured probe as the default into the archive to be able to deploy that from there. Is this your question ?