User Query Tool

User Query Tool

For the past few years I have been working on and implementing a solution (User Query Tool) for the Desktop and Service Desk Teams that will allow for the discovery of the Computer Name simply by entering in a Username, or Serial Number (into the UQT).

Initially UQT was much customised to match the environment which it was built for, but over time I have been removing these deep integration points, along with moving the queries from the simple SQL queries which I ported from SQL reports with hardcoded server connection strings in the early version of the tool, to what I’ve made available today, using dynamically detected SMS Provider connections that can be used in most environments without modifications.

You can download the tool from here

How to use the User Query Tool, so when the tool starts up it will look something like this:

A list of domains which are available in your environment in the dropdown list, which is a mash up of the user’s domains from the SMS Provider & the list of DNS suffix’s on your network adaptors. This is to ensure that it’s a relevant list as both lists by themselves tend to have domains/computer names which will blow out the list. If you don’t see your domain in the list don’t fret, just type it into the field when you complete your search and it should discover the user you have searched for.

When searching on the username you can use partial matches of the username field in Active Directory. For example, I can search for user ‘hoskings’, by typing in the whole name or I can just type in ‘hosk’.

It will return all of the usernames which contain the search string, so if there was hoskings, hoskings-a, and hoskingp it would return all 3 of them which I can then select the account in question.

It is worth noting at this point that it will only return any accounts which have details associated with them, so you will only see relevant information. In future versions though, I might introduce the ability to search Active Directory first for all users which match, but this solution allows for handling of users which exist in domains you might not have access to, along with ensure that you get a fast result.

Once you have selected the user object it will complete the search for computers which the user has logged onto. For multiple computers it will return a list like this:

From here we can select the computer which is the closest match in this case we are going to use StevesRig, which we double click on and you get the following results:

If you double click on each of the text fields it will copy the information into the Clipboard for ease of use, along with the Copy All Results button which is intended to be used for lodging of tickets into your ticketing system as it contains all of the pertinent information required for when logging a ticket.

You will see in the above images that the other buttons are greyed out, they will enable when the tool can either communicate to the computer or Active Directory for the user section. Each of the of buttons do exactly what they say they do J

Please let me know if you have any feedback around this tool, you can see the code for the application at this link:

Comments are closed.