Reports
Creating, editing and viewing reports within SCCM
259 topics in this forum
-
I have some machines that are assigned from a secondary server and have installed w7 but how to create or view a report that states all machines installed or failed in the past?
-
- 2 replies
- 3.4k views
- 1 follower
-
-
I am trying to create a report that lists patch compliance by machine. It would be similar in scope to the standard compliance 3 report Update list (per update). I have no background in SQL and my attempts so far have not been successful. I would like it to take in a collection and update list. I would like it to output something similar to this. Where missing = patches that are required in the update list that are not installed. Where Total is the total number of patches in the list. Compliant just needs to be a percent of the first 2. I would like this to happen for each computer in the collection. Computer Name Missing Total % Compliant …
-
- 3 replies
- 6.1k views
- 1 follower
-
-
Hello All, I am wanting to create a monthly report that queries all machines where a standard users has admin rights (a query that will look at the default admin groups and report back the ones that don't meet these) and any new software that has been installed on that machine in the last month. From what I can see, there isn't a report that shows admin rights, but there is one that shows 'changes' to the machine. Will I need to create a custom report (maybe using SQL views). If so, what tables/keys should I be linking? Thanks, Paul
-
- 2 replies
- 4.1k views
-
-
I have recently removed office pro 2003 from a number of machines on the network. however I spotted one of the machines which no longer has office pro 2003 installed is still showing up when I run report "comptuers with specific software in ADD/REMOVER Programs" it is still reported. I have already changed the schedule for the Hardware Inventory CLient agent to every 5 mins. Any help would be greatly appreciated.
-
- 16 replies
- 9.1k views
- 1 follower
-
-
HI< I have setup a sccm in my LAB (SCCM evaluation package)but when i am going to RUN a report "RUN" option is missing from all reports. Please help me on this and please let me i have missed any configuration regarding the sccm reports.. Regards, Midhun.PS
-
- 1 reply
- 5.7k views
-
-
Hi, i need a report from sms 2003 that count every day the last bootup time for our pc park that is about 30.000 pc's big how to i do this? sql stament dosnt work SELECT v_GS_OPERATING_SYSTEM FROM v_GS_OPERATING_SYSTEM WHERE v_GS_OPERATING_SYSTEM = LastBootUpTime0
-
- 0 replies
- 2.7k views
-
-
Hello all, I just successfully deployed my first batch of patches using SCCM 2007 R2 SP2 and everything is working great. I then went to the SCCM guides that anyweb has made (which are great by the way) and wanted to run the compliance report that is listed in the screens there. When I right click and choose 'run' to run the report I get prompted for credentials. This is odd as I have a service account that has domain admin rights that does all of the other functions on SCCM inclduing OS deployment which has worked with no issues. I attempted to enter these credentials as wel as my own domain admin credentials and I am still unable to run the report. I looked and…
-
- 2 replies
- 5.8k views
-
-
Hi, How to create a compliance report ? I need to create a report where i can get the list of windows machines that have not got the latest updates ?
-
- 0 replies
- 3.5k views
- 1 follower
-
-
Does anyone know how to run a report to show the history of builds on machines i.e. somewhere I can find the old hostnames that have been previously on a number of machines. we have a 15 character hostname which has a format of country code, build type, machine type and the last eight characters made up from the MAC address. However, now we have changed to Win 7 then after the machine has been rebuilt it gets a new hostname to reflect this ( a character in the hostname changes to a 7 from an X to show the change from XP to Win 7). Is there a report in which I can see the history of a machine and its changing hostname?This will help in cleaning up our licensing issues as w…
-
- 0 replies
- 2.9k views
-
-
Hi, I am new to the reporting side of SCCM albiet I have used the built in reports. I am after a report which can show all the software on a computer reported in Add/ Remove programs and also to show its package ID. I want to do this on multiple computers. Everyday I want to run a report from different batches of computers showing want is installed on them with their package ID so I can run this against a known set of package IDs and I'll use a VLOOKUP to give the differences. The reasoning behind this is to show each department exactly what they have on their departments computers but to hide any applications in the lookup table ( these will be mandatory system apps whic…
-
- 0 replies
- 3.5k views
-
-
Hi, I have an urgent requirement to pull out information for all machines including the Last Logged on User Name and the Date. I have been through lots of online reports which are available but none of them worked for me. I even saw a MS Blogpost http://social.technet.mic...ng-configmgr-2007.aspx However, this report is urgent, so I cannot wait for all the machines to start responding back. The Hardware Inventory schedule that we have set is for every 3 days. I would appreciate if someone could please help me with this. Thanks Ricky
-
- 1 reply
- 3.2k views
-
-
Hi all Although my report point server seems to work fine, I'm able to pull reports but I keep getting this error in "Component Status", and "Site System Status" "SMS SRS web service is not running on SRS Reporting point server " Thanks
-
- 4 replies
- 54.7k views
-
-
Hello Im trying to create a report that shows the computer name for every computer in the domain, but also what model(brand) it is. For example Computer Name: XP-44 Computer Model: 245828G (Lenovo) Can anyone point me in the right direction? Thanks
-
- 8 replies
- 24k views
-
-
The management here is asking now to have some numbers and maybe graphs to see how much successrate we have on a certain time base. Is this possible? These numbers are deleted after a while I suppose so giving these numbers will be difficult, no?
-
- 1 reply
- 3.2k views
- 1 follower
-
-
Been trying to come up with a custom report for software not installed on computers. I have setup a report that gives me the computers with the software installed but when I attempt to change it to the NOT IN subset it errors out. error is SYS.Netbios_Name0 cannot be bound. Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion FROM v_GS_SoftwareProduct SP where SYS.Netbios_Name0 not in (Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion FROM v_GS_SoftwareProduct SP JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID WHERE SP.ProductName = 'Microsoft .NET Framework 2.0') any help…
-
- 0 replies
- 3k views
- 1 follower
-
