SCCM - Web Report Editing
Okay There is a web Report in SCCM that will Satisfy 90 percent of what my managers need . Here is the Problem , I still cant get the hang of Targeting a specific Collection. anyone have the mgic Bullet (or sledgehammer) for this ....? I want to change the Client status Deatail for a Specific Computer to a Specific Collection. I am not asking for someone to just solve it , But If I could get a point out of where and the how the solution can be found, it will help me get better SELECT NetBiosName AS [CAM NetBiosName], SiteCode AS [CAM SiteCode], Version AS [CAM Version], LastDDR AS [CAM LastDDR], LastHW AS [CAM LastHW], LastSW AS [CAM LastSW], LastStatusMessage AS [CAM LastStatusMessage], LastPolicyRequest AS [CAM LastPolicyRequest], LastSuccessfulPing AS [CAM LastSuccessfulPing], LastPingTime AS [CAM LastPingTime], LastPingResult AS [CAM LastPingResult], ClientDeployed AS [CAM ClientDeployed], ClientAssigned AS [CAM ClientAssigned], ClientFrameworkHealthy AS [CAM ClientFrameworkHealthy], IsActiveDDR AS [CAM IsActiveDDR], IsActiveHW AS [CAM IsActiveHW], IsActiveSW AS [CAM IsActiveSW], IsActivePolicyRequest AS [CAM IsActivePolicyRequest], IsActiveStatusMessages AS [CAM IsActiveStatusMessages], Obsolete AS [CAM Obsolete]FROM dbo.v_CH_ClientSummary
February 24th, 2010 7:35pm

Hi,If I am not allowed to give you the solution :-) I will point you to a article that describes the process instead - article explains how you can create a a report and add a prompt.Kent Agerlund | | The Danish community for System Center products
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2010 9:00pm

Ha ! that's what I am talking about some one to point me in the right direction, but ..... ERRR... if you HAPPEN to KNOW the solution It would not be beyond me to ask for some Advice. I still want to use that above Query later , But I wrote another one, It just seems to Give me ALL the data on the Logons and I want to filter it down to like anything within the last 30 (again more prompts and filters) this allows me to get all the information from the above Report but add the Last console user and date of last console use and target it to a group (no need for prompts now on this part) and it looks great BUT..... The data goes back to the day of first install of the SCCM server. d'OH! SELECT TOP (100) PERCENT dbo.v_CH_ClientSummary.NetBiosName, dbo.v_GS_SYSTEM_CONSOLE_USER.SystemConsoleUser0, dbo.v_GS_SYSTEM_CONSOLE_USER.LastConsoleUse0, dbo.v_CM_RES_COLL_HS1000FF.IsClient, dbo.v_CM_RES_COLL_HS1000FF.IsAssigned, dbo.v_CM_RES_COLL_HS1000FF.IsActive, dbo.v_CH_ClientSummary.LastDDR, dbo.v_CH_ClientSummary.LastHW, dbo.v_CH_ClientSummary.LastSW, dbo.v_CH_ClientSummary.LastSuccessfulPingFROM dbo.v_CH_ClientSummary INNER JOIN dbo.v_CM_RES_COLL_HS1000FF INNER JOIN dbo.v_ClientCollectionMembers ON dbo.v_CM_RES_COLL_HS1000FF.ResourceID = dbo.v_ClientCollectionMembers.ResourceID AND dbo.v_CM_RES_COLL_HS1000FF.IsClient = dbo.v_ClientCollectionMembers.IsClient ON dbo.v_CH_ClientSummary.NetBiosName = dbo.v_CM_RES_COLL_HS1000FF.Name INNER JOIN dbo.v_GS_SYSTEM_CONSOLE_USER ON dbo.v_ClientCollectionMembers.ResourceID = dbo.v_GS_SYSTEM_CONSOLE_USER.ResourceIDORDER BY dbo.v_CH_ClientSummary.NetBiosName
February 25th, 2010 7:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics