Archive Page


Is it possible to query sccm/sql to get OS version and ...

Mar 12, 2015· In SCCM, is there a SQL query I can run to get the clients OS version and the version of Flash Player that is installed? I have been able to get the OS version but just not sure how to combine the two? ... In this example I am replacing the "version" name with the friendly name. SELECT v_R_System.Name0, Replace (Replace ...


@@SERVERNAME (Transact-SQL) - SQL Server | Microsoft Docs

Sep 07, 2018· Returns the name of the local server that is running SQL Server. Transact-SQL Syntax Conventions. Syntax @@SERVERNAME Return Types. nvarchar. Remarks. SQL Server Setup sets the server name to the computer name during installation. To change the name of the server, use sp_addserver, and then restart SQL Server.


SQL SERVER - SQL Authority with Pinal Dave

Nov 12, 2016· There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it. Command Prompt. Based on my research, registry key would have an entry whenever SQL is installed. So we can query the registry key to find details about instance name.


Query host name in SQL | Oracle Community

Aug 02, 2016· Duncan Gardner wrote: Just in case someone finds this useful. Please expand/correct This will give you the host name of the database/instance you are …


How to get Host name and SQL Instance Name by T-SQL

Mar 27, 2018· I am using SQL 2000, 2005 and 2008. I have few multi instances SQL servers. I would like to gather following information: Host Name SQL Instance Name SQL Version Server1 Server1 SQL 2000 Server1 Server1ABC SQL 2005 Server1 Server1XYZ SQL 2008 Server2 Server2 · SELECT SERVERPROPERTY('MachineName') AS [ServerName], SERVERPROPERTY('ServerName') AS ...


SCCM 2012 – List of SQL queries – Karthick Jokirathinam's blog

where b.Name0 like 'Machine name ... 4 Comments on SCCM 2012 – List of SQL queries FirstJami // September 27, 2017 at 11:22 am // Reply. I see you don't monetize your blog, don't waste your traffic, you can earn extra cash every month because you've got hi quality content. If you want


SCCM SQL query to get the Machine Name and IP address ...

Mar 03, 2014· Any one can helpt me to get the SCCM SQL query for getting the Machine Name and IP address based on collection. Monday, February 24, 2014 3:27 PM. Reply | Quote Answers text/html 2/24/2014 3:43:24 PM Prabha G 0. 0. Sign in to vote. Check these Pls. You will get the solution ... Check these Pls. You will get the solution


SQL Query To Count Computer Types For A Specified ...

May 18, 2014· SQL Query To Count Computer Types For A Specified Collection Name SQL: Select CN.Name 'Collection Name', Case SE.ChassisTypes0 When 1 Then 'Other' When 2 Then 'Unknown' When 3 Then 'Desktop' When 4 Then 'Low Profile Desktop' ... SQL Query Get Machine and User Information From A ...


SCCM SQL Query : To Get Members Of A Specified Collection

SCCM SQL Query : To Count The Number Of Client Mac... SCCM SQL Query : To List Machines With IIS, FTP O... SCCM SQL Query : To Retrieve Clients Last Boot up ... SCCM SQL Query : Get Machine and User Information ... SCCM SQL Query : To Enumerate ConfigMgr 2007 Bound... SCCM SQL Query : For Windows Media Player Versions...


SQL Queries FOR SCCM | Vasanthblog

Feb 10, 2012· SQL Query To Retrieve Advanced Clients Assigned Site Code And Client Version This SQL Query will allow you to list the assigned site code and client version numbers for your advanced client resources. SQL Query: Select SD.Name0 'Machine Name', SC.SMS_Assigned_Sites0 'Assigned Site', SD.Client_Version0 Version From v_R_System SD Join v_RA_System_SmsAssignedSites SC …


SQL Query to find machine information in SCCM - Tech Blogs

Apr 24, 2013· SQL Query to find machine information in SCCM April 24, 2013 The below query provides the hostname,AD SITE Name,Username,Client version,creation date,Operating System of a SCCM client installed machine. ... (Where number= the version,check for the highest number available in system32 folder)


ORACLE-BASE - Identifying Host Names and IP Addresses

Identifying Host Names and IP Addresses in SQL and PL/SQL ; UTL_INADDR. The UTL_INADDR package was introduced in Oracle 8.1.6 to provide a means of retrieving host names and IP addresses of remote hosts from PL/SQL. The GET_HOST_ADDRESS function returns the IP address of the specified host name.


How to find out user name and machine name to access to ...

For example, I log in in as my name to SQL server. The result of this query only lists my name and machine name. This query does not list current users on the SQL server. exec sp_who2 lists information I need. It lists current user name machine name, active status, db name …


SQL SERVER - SQL Authority with Pinal Dave

May 26, 2009· HI Pinal, We can find out the the computer Name (Host Name) using HOST_NAME() in SQL SERVER, in the same way how could we find out the name of the user who have logged into the machine/OS.. if could we see that means it will be helpful in the audit.


SCCM SQL query to get the Machine Name and IP address ...

Mar 02, 2014· Any one can helpt me to get the SCCM SQL query for getting the Machine Name and IP address based on collection. Monday, February 24, 2014 3:27 PM. Reply | Quote Answers text/html 2/24/2014 3:43:24 PM Prabha G 0. 0. Sign in to vote. Check these Pls. You will get the solution ... Check these Pls. You will get the solution


HOST_NAME (Transact-SQL) - SQL Server | Microsoft Docs

Sep 21, 2017· When the parameter to a system function is optional, the current database, host computer, server user, or database user is assumed. Built-in functions must always be followed by parentheses. System functions can be used in the select list, in the WHERE clause, and anywhere an expression is allowed ...


How To Find the Collection Membership Information of a ...

Aug 24, 2009· Many times during the course of troubleshooting you may come across a situation where you need to find out how many Collections a specific Client machine is a member of. Here is how you can find that information, along with the Collection Names and the ID's: Run the following query in SQL against the SMS...


How to find SERVER NAME and LOCAL MACHINE Name in SQL ...

Oct 22, 2009· -NetBIOS name of the local computer on which the instance of SQL Server is currently running. -For a clustered instance of SQL Server on a failover cluster, this value changes as the instance of SQL Server fails over to other nodes in the failover cluster.


SQL Tips & Tricks: Get COMPUTER NAME from SQL Query

Apr 28, 2007· Get COMPUTER NAME from SQL Query Get the HOST NAME / COMPUTER NAME Get the Computer Name using SQL Query Select Host_Name() as Computer_Name ... How to check if a text exists within another in SQL Server 2008 / How to split SQL Column based on Comma You can use the combination of Ch...