Reports
Creating, editing and viewing reports within SCCM
259 topics in this forum
-
Hi I was planning to do some housekeeping on DPs by removing unsued packages. Got a sql query from somewhere which gives the package details are associated with expired Ads which helped me to find obsolete packages and its easier to remove those from DPs and free some space. SELECT PackageID, Name, Version, Manufacturer, Language, Description, PkgSourcePath AS [source Path], LastRefreshTime, (SELECT COUNT(PkgID) FROM vPkgStatusSummaryDistPts WHERE PkgID = v_Package.PackageID) AS [No of DP] FROM v_Package WHERE PackageID NOT IN (SELECT PackageID FROM v_Advertisement) AND PackageID NOT IN (SELECT ReferencePackageID FROM v_TaskSequenceReferencesInfo) AND PackageType …
-
- 1 reply
- 3.6k views
- 1 follower
-
-
hi, is it possible to create a report, that shows me which collection a user or computer is a member of? Best regards Aquintus
-
- 2 replies
- 8.3k views
- 2 followers
-
-
Would anyone please be able to help me with a report that gives me all the computers with there last logged on user and the last logged on time? I am currently using this but it does not tell me the last logged on time.. SELECT distinct sys.Netbios_Name0 ComputerName, sys.user_name0,ipsub.IP_Subnets0, ip.defaultIPGateway0, sys.AD_site_name0 ADSite from v_R_system sys inner join v_GS_Network_Adapter_Configur IP on sys.ResourceID=IP.ResourceID inner join v_RA_System_IPSubnets ipsub on sys.ResourceID=ipsub.ResourceID where sys.resource_domain_or_workgr0 = 'AUASCARLSON' and sys.obsolete0=0 and ip.defaultIPGateway0 is not NULL and ipsub.IP_Subnets0 is not NULL; It is …
-
-
- 4 replies
- 5.1k views
- 1 follower
-
-
Hi, I have SCCM 2012 environment with multiple DP's. I need to identify which DP is used for deploying packages to the clients. Can we get this information in reports or any log files? This will ensure that correct DP is being used for the entire collections. Regards
-
- 4 replies
- 24.1k views
- 2 followers
-
-
Hi all, I am new to SCCM 2012 and was looking at the Automatic Deployment Rules. Is there a way to send out an e-mail of all details of the ADR after it has completed? We want to automate the monthly patching for our mutliple tier environement and receive a complete status report once it has completed. Can this be done? Thanks, Michael
-
-
- 8 replies
- 5.8k views
- 3 followers
-
-
Hi all Looking for SQL query to generate a report which will list down the packages which does not have an active advert for all the DPs.
-
- 0 replies
- 2.6k views
- 1 follower
-
-
hi there, im kinda new in sccm, and in creating custom reports. actualy i need a huuuuuge information in one report. -netbios name -ad container -current user -top console user -vendor -model -processor type -numer of processor cores -GHz of processor -how many ram is there -os version and name -video card model and its ram -hdd type and size -hardware production date (when created) -last logon i tryed to do something, but its insane to understood how its works and writes oh, forgot to tell that im using sccm 2007 got some code already with half of everything, but i still getting error "Must Declarare the scallar Variable @CollectionI…
-
- 8 replies
- 9.2k views
- 1 follower
-
-
Hi! How create sccm 2012 reports for all MAC address after collection?
-
- 3 replies
- 14.7k views
- 1 follower
-
-
We had an issue a week ago where for whatever reason some of our machines lost their windows activation. What I'd like to do is run a report that shows all the machines where the activation field is blank. Or at least show me the field(s) where the Status Not Available or Poduct ID: Not Available is so I can at least determine what machines at a glance have an issue. I just don't know what table and fields I need to reference in order to build the report. I have noticed the licencestatus0 in VS_GS_SOFTWARE_LICENSING_PRODU table that yeilds a value of 0, 1 and 3. Which is the one that shows registered and not registerd or available?
-
- 0 replies
- 4k views
-
-
Does anyone have an idea on this one?
-
- 3 replies
- 6.1k views
- 1 follower
-
-
Im using SCCM 2007 R3 on a 2008 R2 server. I want to deploy a msi package to all computers in our domain and want to check deployment status with reporting. I have created a report like described here http://blog.coretech.dk/kea/creating-configuration-manager-2007-reports-part-ii-creating-the-first-reports/ using V_R_System and V_GS_Add_Remove_Programs but this reports only show those computers wich I have manually deployed the msi package. Those who has gotten the msi package pushed from sccm doesnt show up in the report. In both deployment cases I can see the font package in add/remove programs. Is there any other/better way to check if software is deployed so I can rem…
-
- 1 reply
- 3.3k views
-
-
Hi, we have 2 subnets and some computers have 2 (or more (for backup-subnet)) network adapters. how do i create a custom report to display the Computername, Current User, Adapter descriptions, IP, MAC, Subnet? Like "network adapter information for a specific computer" but with user and not a specific computer but for all computers in all subnets Regards
-
- 1 reply
- 3.3k views
-
-
Hi, i am getting some problem for patching report in sms server, as the patching result is not showing up for the following bulletins articles in sql and sms server. MS11-087 MS11-089 MS11-099 i can pull the reports for other bulletins , can anyone help on this ? Thanks.
-
- 1 reply
- 3.6k views
-
-
Hello - I'm new to SCCM, and trying to run a report for management to see which systems need upgraded. I tried to run the report "Search for Computers" and put in the collection "Workstation and desktops", and comes back with a 500 internal server error. It works fine with other reports, but this one will be about 17000 computers. Just need computer type and computer name.. Thanks!!!
-
- 1 reply
- 4.4k views
-
-
Hi, I have Sccm 2007 on my system. I'm trying to get software informations from computers in a specific OU, example: I want to get a list of all software which is installed on workstations, which are in the Sales OU in my Active directory. Do you have any informations on how to pull that kind of report out of SCCM ???
-
- 1 reply
- 6.1k views
- 1 follower
-
