Messages

Ok great so this is a known issue and when report v1.1 comes out they will have all the updated apps?

I ran that report over 70 times doing scans on each 3rd party app on a collection. I had apps that were 1 or 2 unique devices all the way up to 5000+ unique devices. I don't think it has anything to do with how many devices the report finds. Either way the report will NOT export the logo or Unique Devices and Unique Versions.

Andy K

Not sure how many Unique Versions for the 04 report since that part doesn't export. As you know my issues with report 04 is that there are NO Unique Versions exported at all.

Sorry this might be in the wrong forum. Please move if needed.

Andy K

Sorry this might be in the wrong forum. Please move if needed.

Andy K

When I run report "04 - Installed Third-Party Applications" and use the drop down box to select which app I'd like to look for. I get a list of 62 applications. But when I look in SCUP I see there are more than 62 apps such as Gimp and ImgBurn that don't show up in the drop down list for the report. Is that by design or is my report not querying all the apps in SCUP? Or maybe they are just listed as different names? Not a big deal since its a few minor apps just wondering.

I can provide a full list that my report is getting if needed.

Thanks,
Andy K

I'm not sure if it is true for other reports as well or not. I do know report "06 - Installed Third-Party Applications Detailed" has the Unique Devices listed on the top of the document and when you export that to MS Word it DOES export. So 06 it works fine. I haven't checked any other reports yet.

Thanks,
Andy K

If you run report "04 - Installed Third-Party Applications" on the console and look at the bottom of the page it shows the PatchMyPC logo on the left and more importantly it lists Unique Devices and Unique Versions. But then when I export that report to MS Word and scroll to the bottom of the page the logo is gone as well as the Unique Devices and Unique Versions.

Is there anyway you could include the Unique Devices and Unique Versions in the export?

See below for examples.

Thanks,
Andy k

I've also talked to Justin about how the new report should work. Email details below:



Thanks for the feedback we will keep this in mind when looking at creating the reports.

Thanks,

Justin
Patch My PC Support
Patch Management Made Easy!
Support Number: +1 (720) 408-4659
Support Email: [email protected]
Support Forum: https://patchmypc.net/forum

From: Andy Konczak [mailto:[email protected]]
Sent: Wednesday, December 7, 2016 8:10 AM
To: Patch My PC Support <[email protected]>
Subject: RE: SCUP Catalog - Technical Support - Entrust Datacard

Oh and one other thing IÔÇÖve thought of. If you do go ahead and create this report, which I really really hope you do, could you make it so you can either select all or select say 2 apps or select 5 or 10 etc? IÔÇÖd like to be able to take a device group then at first run against all the 3rd party PatchMyPC app list. Then once IÔÇÖve verified most are not even installed IÔÇÖd like to run again just the ones that are to save SQL time etc. Then in the future when there are only a few 3rd party apps still left IÔÇÖd like to be able to select just a few. So maybe a check box type of search for the apps against a device group. Something like that would be amazing! Thanks!

Thanks,
Andy Konczak

Thanks Justin I really appreciate the help! I'm sure I won't be the only one who will use this report once completed. Again let me know if I can help at all.

Andy K

Who created the current PatchMyPC reports? Who ever did them did a great job! It seems like whoever created those would have the knowledge and experience to create what I'm looking for as well.

Yes I agree it will probably be pretty SQL intensive but even if it takes 5 or even 10 minutes for this report to gather all the data and put it into a report. That will still be 10,000 times faster than me running all the reports separately one by one then putting all the data into a single report manually. My primary site server is also my report server so it a brand new 2012 R2 VM with a lot of hardware. So I'm not worried about pushing it too hard. It only runs at 4% when I run other large reports. Its a nice quick server.

I have 317 servers in my device group that I need to know all the 3rd party apps on and their version. Then I'll go and uninstall what is NOT needed or approved. What is left I'll update. But to get that info I'd need to run 76 reports on the device group with 317 servers in it. I guesstamate that would take a few days. And I'll need to run this report once a month to verify its all keeping secured.

Thanks again for your help! If there is anything I can do please let me know.

Andy K

Attached below is a screen shot of my custom report that allows multiple Display Name values for report 04. But when I select more than 1 I get this error below:



Microsoft.Reporting.WinForms.ReportServerException
An error has occurred during report processing. (rsProcessingAborted)


Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

-------------------------------

Microsoft.Reporting.WinForms.ReportServerException
Query execution failed for dataset 'Chart'. (rsErrorExecutingCommand)


Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

-------------------------------

Microsoft.Reporting.WinForms.ReportServerException
Incorrect syntax near ','.


Stack Trace:
   at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report)
   at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation()
   at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation()
   at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)

-------------------------------

So far all I can see to do is run report 04 on the same collection aka device group over and over and over for each app. Then I'd need to manually collect all that data and place it into my own report saying this device collection has these 3rd party apps installed, therefore I need to updated X these 3rd party apps. That might take a few hours and can but done but it would be really great if I could get a single report to do the work for me.

Anyone with custom report skills that could help me build that?

Another issue is if I run report 04 over and over for each app I also have about 4 device groups. So lets say 4 groups, I count 67 3rd party apps right now, so that's 268 reports I'd need to compile info for

Andy K

I've tried to modify both reports 04 and 06 to allow the product in 06 and Display Name in 04 to allow multipule values but it doesn't come up with anything even though I know some of the apps I'm selecting on my list are installed on my collection. And if I run the report for single apps it works. So I'm going to keep looking but any help is appreciated.

I've even tried separating the apps by semi colon like so but no luck. Just blank or error.
7-Zip;Adobe Acrobat Pro;Adobe Air;Adobe Flash Player

Andy K