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: (9)

Delete technician from drop down assign menu Manage Engine ServiceDesk Plus

How to delete a technician from the drop down assign ticket menu in Manage Engine ServiceDesk Plus.

Connect to the database.

Run this query to get the technician ID’s.

Select au.user_id"Userid",au.first_name"Name",sd.status"Status",hc.technicianid"Technician ID" from HelpDeskCrew hc left join AaaUser au on hc.TECHNICIANID=au.USER_ID left join AaaLogin al on al.USER_ID=au.USER_ID left join SDUser sd on sd.USERID=au.USER_ID

Then delete them from the helpdeskcrew table.

delete from helpdeskcrew where technicianid=’$insertTechnicianIdHere’;

 

We had one error come through with a purchase request & order being created by one of the staff, I had to delete this request and order before it would let me delete them from this table.

 

Restart the application once done, and all good!

Total Views: (24)

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. As users use their own logins to login here, a computer policy is the best option as it removes the need for a ‘loopback’ policy which can cause great annoyances with GPO’s.

 

The required GPO settings for this can be found here:

Once implemented, the Start Menu now looks like this:

 

You’ll also notice the Security Option which removes the shutdown option from the log on screen!

Voila!

Total Views: (18)

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.

https://github.com/Nostalgiac/Scripts/blob/master/Shadow-RDSSession.ps1

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 and Session Host.

 

The main gist of it is in these two lines….


$result = invoke-command -computer "DomainController" -scriptblock {Get-RDUserSession -ConnectionBroker "ConnectionBroker" | Select-Object -Property Username,HostServer,UnifiedSessionID} -Credential $credentials

Start-Process mstsc -Credential $credentials -ArgumentList "/shadow: $($newResult.UnifiedSessionId) /control /v: $($newResult.HostServer) /noConsentPrompt"

However I’ve wrapped up the results into a little GUI and have a nice connect button to make it as easy as possible for helpdesk staff.

 

 

Total Views: (78)

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 SERVICE’.

 

Checking the error.log for WID – C:\Windows\WID\

Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. Reason: Failed to open the explicitly specified database ‘SUSDB’.
Error: 18456, Severity: 14, State: 38.

 

The solution:

Uninstall KB3148812

More info: https://blogs.technet.microsoft.com/wsus/2016/04/22/what-you-need-to-know-about-kb3148812-part-two/

Update

https://blogs.technet.microsoft.com/wsus/2016/05/05/the-long-term-fix-for-kb3148812-issues/

Install KB3159706

Then run the post-install steps from the link above.

Total Views: (10707)

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 Monitoring -> Queries.

SCCM 2012 R2 Query:


SELECT SMS_R_System.LastLogonUserName, SMS_R_System.Name, SMS_R_System.LastLogonTimestamp

FROM SMS_R_System

Press CTRL + A then CTRL + C to select the results of the report and copy it to a clipboard. Open up excel and paste the values in.

At this point I removed all the rows with blank usernames.

Insert a new  at the top and fill it in the respective rows with the headers username, computer, lastLogon, department

It should look like this:

Save the file as a csv  and name it something like SCCMExport.csv

Next, copy the following PowerShell script and modify the filename variables to be appropriate ($data and $outputFileName)


$data = Import-Csv "SCCMExport.csv"
$outputFileName = "ComputerbyDepartment.csv"

$outputCSV = New-Object System.Data.DataTable
$outputCSV.Columns.Add("username") | Out-Null
$outputCSV.Columns.Add("computer") | Out-Null
$outputCSV.Columns.Add("lastLogon") | Out-Null
$outputCSV.Columns.Add("department") | Out-Null

foreach ($user in $data){
$department = Get-ADUser -Identity $user.username -Properties Department | select -ExpandProperty department
$row=$outputCSV.newrow()

$row["username"]=$user.username
$row["computer"]=$user.computerName
$row["lastLogon"]=$user.lastLogon
$row["department"]=$department
$outputCSV.rows.add($row)
}
$outputCSV | Export-CSV $outputFileName -NoTypeInformation -Append -Force

All done. Check the OutputFile to see all the Departments listed neatly next to the users and computers.

Total Views: (1156)

Citrix on Mac OS X – You have chosen not to trust ‘SSL provider’ the issuer to the server’s security certificate

Citrix ICA Client: SSL Error 61: You have not chosen to trust “VeriSign/Go Daddy/Rapid SSL etc”, the issuer to the server’s security certificate.

What you need to do is install the full SSL Certificate Chain.

You can get view which chain you need by going to the StoreFront website and clicking the view certificate button.

Then follow these instructions to install BOTH the Intermediate and the Root certs.

http://support.citrix.com/article/CTX114146

Pro Tip: You don’t have to SFTP/SSH the certs to the NetScaler if it’s in your DMZ and don’t have access, you can create new files using the ‘Install’ button and just copy/paste the cert contents into the ‘new file’.

If you get an error “No Certificate Found for Linking” then you are uploading the wrong chain of files.

Once you have both certificates uploaded, click on your initial SSL cert, and link it to the intermediate cert you just uploaded. Then click the intermediate cert and link it to your root cert.

With this all done the Mac will be able connect succesfully to your citrix session!

 

 

Total Views: (478)

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 server address, correct gateway address) but still just times out upon trying to connect.

Turns out to be the IIS ARR at fault.

Click on Server Farms -> gatewayurl.domain.com -> Proxy -> Buffer Settings -> Set Response buffer threshhold (KB) to zero (0) -> Apply

Refresh your RDWeb page and it will instantly connect!

Total Views: (738)

Show individual pageviews in Google Analytics

For something so simple there seemed no RECENT guides on how to show the page views for an individual page in Google Analytics.
All you need to do is browse through:
Behavior -> Site Content -> All Pages -> Click on the page you’d like to view.

 

Total Views: (4)

How to pin KiTTY to the taskbar

After failing to get KiTTY to pin to the taskbar through various methods of creating shortcuts etc, all I had to do was the following.

Download the PuTTY Installerhttp://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
Download the KiTTY exe – http://www.9bis.net/kitty/?page=Download

Install PuTTY.
Copy the KiTTY.exe into the PuTTY installation folder (default: C:\Program Files (x86)\PuTTY)
Now drag the KiTTY.exe from the PuTTY folder onto the taskbar!

Total Views: (73)