Count of File Created Date Wise - PowerShell

Below Powershell command is must have during your troubleshooting in SCCM site server file backlog like DDR, RDR or state message backlog. Below Powershell command will give your output of count of file created based on date against any file location. Get-ChildItem "D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\regreq" |...

Read More

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

How to corrupt or malfunction WMI manually

During general troubleshooting or SCCM(System Center Configuration Manager) troubleshooting at client side, we may need to intentionally corrupt or malfunction WMI(Windows Management Instrumentation). However its not recommended to modify/malfunction WMI. As we know that WMI is heart of OS(Operating System) as well as of SCCM. If it gets corrupted,...

Read More