Search the Community

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

Hi guys, We're looking at spinning up App-v in our environment to handle some finnicky Office 32-bit addins that we use for some line of business applications in my organization. My question : we've already got a working SCCM 2007 infrastructure, with SQL server and everything in place; is it possible to install App-V on a separate VM or even the same VM with SCCM and store the database for App-V in a separate instance on the same SQL server? Is this a bad idea? Also, how big of a deal is it to setup App-v? I'm intrigued by the idea and would love to experiment with some additional Microsoft products, especially since we have the all-you-can-eat licensing agreement as it is. Thanks!

Hello, I have a problem installing SCCM 2012 on the SQL 2008 R2 cluster. When it goes through the prerequisites, and I specify my SQL server, it connects fine, but when it comes to creating the database on the server it fails, saying that it can’t connect to the server. I tried a different approach and installed a local copy of SQL 2008 R2. SCCM installed fine. I moved the database to the SQL cluster, tried to re-point to use cluster and it failed again. Here is some log from the attempt to re-point to cluster: INFO: SQL Connection succeeded. Connection: clustername.domain MASTER, Type: Unsecure $$<Configuration Manager Setup><04-27-2012 10:32:34.107-60><thread=4056 (0xFD8)> INFO: SQL Server clustername.domain is clustered. $$<Configuration Manager Setup><04-27-2012 10:32:34.193-60><thread=4056 (0xFD8)> *** [08001][-2146893022][Microsoft] SSL Provider: The target principal name is incorrect.~~ $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)>*** [08001][-2146893022][Microsoft][sql Server Native Client 10.0]Client unable to establish connection $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)> *** Failed to connect to the SQL Server. $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)> INFO: SQL Connection failed. Connection: SMS ACCESS, Type: Secure $$<Configuration Manager Setup><04-27-2012 10:32:34.202-60><thread=4056 (0xFD8)> I tried to connect using the ODBC connection, name resolution and it was ok. Then I tried to use IP address instead of the name and I also used domain admin account and the same result. I would appreciate your help.

Hi there, WQL and SQL totally escapes me so I was wondering if someone could help. I'm after creating a report that will show users that have logged on to multiple machines and also list these machines... My Project manager asked spcifically for a report that displays users that have (in their possession) both a desktop and a laptop but I'm guessing my method would be easier. I believe you can also report on the primary user depending on the % of time a user has been logged on to a machine - maybe this could help narrow the results down further?? Hope someone can help - or at least understand my request ) Chris.

I'm trying to plan for SCCM 2012 and I'm curious if anyone has a good idea what I can expect for SQL database growth? Or put another way, tools or other methods available to help me scale out the database server? I'm guessing around 4,000-5,000 clients will be reporting in to this system. Any help or direction would be greatly appreciated! Regards, Ben