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.
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!
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.
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
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)
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.
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!
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!
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.