How to identify SQL Server job owner

I was trying to remove a user from SQL Server database box but while trying to remove the user, I got below error: Now in order to identify where the user has create a SQL Server job, you can run below query to get the job details owned by the user. Here we go: Select...

Read More

How to Get Collection Folder Location in SCCM

Your manager rushes to you and asks you to identify the Folder location of a culprit collection. You goes to SCCM console and search for it either with name or collection ID. You get the half detail but your manager asked for folder location and you scratches your head because...

Read More