|
|
Browse by Tags
All Tags » vNext (RSS)
Showing page 1 of 7 (63 total posts)
-
For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f Select
CS.Name0 as 'PC Name',
OS.Caption0 as 'OS',
OS.CSDVersion0 as 'SP'
From
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_SERVICE S on CS.ResourceID = ...
-
If you are trying to install CM12 console on a workstation, you will receive the following error: Input string was not in a correct format. The solution is to browse the DVD and smssetup\bin\i386 and execute the AdminConsole.msi.
-
So I have been running with my head cut of these days but I always like to make sure that the Reporting forum questions are answer... http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/threads For more detail about each of the post see: ...
-
For full details see:
http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/4e4019b0-a28e-4637-ae8c-4ff523d11c1a select top 3
Manufacturer0,
Count(*)
from
dbo.v_GS_COMPUTER_SYSTEM
GROUP BY
Manufacturer0
Order by 2 desc
-
For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f96191-6e3e-4150-8f3a-18b1c4db8d7d SELECT
R.Netbios_name0,
R.AD_Site_Name0,
ARP.DisplayName0,
ARP.InstallDate0,
DATEDIFF(Day, CONVERT(Datetime,ARP.InstallDate0), GETDATE()) AS [days since ...
-
For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/66c80e66-9760-49b3-b429-08bf2ca8f572 http://social.technet.microsoft.com/Forums/en-US/configmanagerapps/thread/b68ce42c-98f5-4500-bced-0e8e901cb211/ select distinct ...
-
For full details please see http://www.myitforum.com/Forums/tm.aspx?m=230539&high= SELECT DISTINCT
R.Netbios_Name0,
tu.SystemConsoleUser0,
tu.logontime
FROM
dbo.v_R_System R
join (
SELECT
husr.ResourceID,
Husr.SystemConsoleUser0,
max(Husr.LastConsoleUse0) as logontime
FROM
dbo.v_HS_SYSTEM_CONSOLE_USER ...
-
For full details, please see this forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/50b2b524-3c11-41c5-a2d5-b8ae979ee3c2/ Select
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0,
sys.Operating_System_Name_and0,
arp.DisplayName0,
ARP.Version0
FROM ...
-
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/db96da44-a9e0-4996-bca2-286b6e2c473a SELECT DISTINCT
CS.Name0,
HARP.Publisher0 AS 'Publisher',
HARP.ProdID0 AS 'Product',
HARP.DisplayName0 AS 'Name'
FROM
dbo.v_GS_COMPUTER_SYSTEM CS
join ...
-
Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened: My passport expired so had to get a new one, I picked it up on Thursday just before I left for Vegas I know my luggage would be close to being overweight, so I didn’t bring a few things like shaving cream. I’m ...
1 ...
|
|
|