I am trying to report 'Top Console User' by using a Sql substring and need to remove the "domain/" from "domain/username." Using the substring, I would like to only get back the username by removing everything before the forward slash.
Searching the internet and these forums, I was unable to find something about using the "/" character. I have found some good articles on substrings but I cannot get the function to work with this character. Does anyone know how I could create a query to find top console user and remove the "domain/" ?
Thank you in advance for the help! This is my first post, so please let me know if this should be posted in another forum.
I'm using SQL Server 2008 R2 and Configuration Manager 2007
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
I am trying to report 'Top Console User' by using a Sql substring and need to remove the "domain/" from "domain/username." Using the substring, I would like to only get back the username by removing everything before the forward slash.
Searching the internet and these forums, I was unable to find something about using the "/" character. I have found some good articles on substrings but I cannot get the function to work with this character. Does anyone know how I could create a query to find top console user and remove the "domain/" ?
Thank you in advance for the help! This is my first post, so please let me know if this should be posted in another forum.
I'm using SQL Server 2008 R2 and Configuration Manager 2007
Share this post
Link to post
Share on other sites