Clearing the ConflictandDeleted Folder DFSR

Clearing the ConflictandDeleted Folder DFSR Windows Server 2012 R2. List the DFS Replicated Folders: WMIC.EXE /namespace:\\root\microsoftdfs path dfsrreplicatedfolderconfig get replicatedfolderguid,replicatedfoldername Paste in the GUID of the folder you would like to clean up. WMIC.EXE /namespace:\\root\microsoftdfs path dfsrreplicatedfolderinfo where ‘replicatedfolderguid=”70bebd41-d5ae-4524-b7df-4eadb89e511e”‘ call cleanupconflictdirectory Wait a few minutes! Done!   Total Views: (30)

Remove Shutdown from Start Menu – Computer Policy

Remove Shutdown from Start Menu by Computer Policy Prevent users from shutting down or restarting computer once again through computer policy. The reasons for doing this, and not using the standard ‘user policy’ which removes the shutdown option from the Start Menu, is because the organisation required this for a bunch of meeting room computers. […]

Shadow RDS Session PS Script for Helpdesk Staff

I wrote this PowerShell script so that our Helpdesk staff were able to view the Remote Desktop Sessions on our 2012 RDS Hosts and shadow them. The script queries the RDS farm with Get-RDUserSession by invoking this command on your Mangement Server (that has the RDS Tools installed), then starts mstsc with the appropriate session ID […]

Cannot open database “SUSDB” requested by the login. The login failed.~~Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

Unable to synchronize updates with SCCM 2012 R2 with WSUS using a Windows Internal Database. WCM.log – SCCM\Microsoft Configuration Manager\Logs\ Cannot open database “SUSDB” requested by the login. The login failed.~~Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’ System.Data.SqlClient.SqlException — Cannot open database “SUSDB” requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK […]

Last User Logged In To Computer with SCCM and Powershell

Recently tasked with getting a list of all users who were last logged into a computer, and then finding their department (AD department attribute) based on that user account. This is to get the department each computer is associated with so they can be cost-coded to. Add and run the following query into SCCM under […]

Remote Desktop Gateway behind IIS with ARR

Unable to connect to a RDP Gateway Session Host when it is behind IIS running Application Request Routing. IIS  -> Remote Desktop Gateway Web Access -> Remote Desktop Gateway Session Host. Everything worked internally, connecting externally to the web server works fine and the actual rdp file that is downloaded and runs looks fine (correct […]

Restore Dumpster Items from Exchange 2013 Backup

Restoring mail from the ‘Recover Deleted Items’ section aka the dumpster from an Exchange 2013 Backup database. All of the following commands were run through the Exchange Management Shell. This is easiest done if the database & log folder have been restored (we used Backup Exec 2014) to a local drive on the Exchange Database […]

Surface Pro 3 PXE Boot skips IPv4

Surface Pro 3 PXE Boot skips IPv4, Surface Pro 3 PXE goes straight to IPv6. After PXE Booting the SP3, you could see it flash something after the message about IPv4 and goes straight to IPv6, then eventually times out and boots normally. I used my iPhone Slow-mo camera to record this process and then view what […]

Diagnosing missing webapp data through MSSQL

The case of all recently made redundant employee’s had disappeared from our HRM after they received the payout. Return all the recently run queries: Searched the recent results for the table ‘q2employees’ as this references all the employee details, I knew this would need to be included. One of these large queries pointed to a view […]

Update SharePoint list from CSV File using Powershell

Updating a SharePoint list from a CSV File using PowerShell. Only update the matching list items, does not create new entries. This checks the SharePoint list for the two columns, ‘Employee’ and ‘Titlex’ – and then will update them matching the csv file to the ‘givenName + sn’ fields. It updates only the ‘Primary Program’ SharePoint […]