Jump to content


GarthMJ

Moderators
 View Profile  See their activity

  • Posts

    1939

  • Joined

  • Last visited

  • Days Won

    92

 Content Type 

Everything posted by GarthMJ

  1. GarthMJ
    If reports work at all then it is not a problem with reporting. It is going to be a problem with your MP or something else. Check the health of you MP.
  2. GarthMJ
    This is exactly what I do! If they can't be bothered to do it when it is better for them, then how can I be blamed for it.
  3. GarthMJ
    If the problem is the temp db, then issue is likely that someone is running a poorly written query that is filling it up. You can fix it bad capping the temp DB size but that will make the query stop working too. Once you figure out what is filling up all the space you and work on how to fix it.
  4. GarthMJ
    And Where is your Temp db? Have you looked to see what exactly is eating up all the space?
  5. GarthMJ
    I assume your "no" it is my first question, if so when how are they different? and what about my other question like Disk IO and Memory? What about SQL and RAM?
  6. GarthMJ
    So No CAS, right? Does all three primary site behave the same way? Are all 3 primary servers exactly the same with CM12 R2? Is your C:\ running out of space? Is SQL consuming all the RAM? What is you Disk IO like? What is Memory like? aka are you paging a lot?
  7. GarthMJ
    What do you mean 3 different sites? 1 Primary and 2 secondary sites? 3 primary sites? 1 CAS - 2 Primary sites? (Why would you have a CAS??? Do you have over 100K of PCs?)
  8. GarthMJ
    If off I never recommend that you access the reports via the console. Too much over head. http://be.enhansoft.com/post/2013/09/10/Should-Configuration-Manager-SSRS-or-ASP-Reports-be-Accessed-from-the-Browser-or-the-Console.aspx It sound like you have a permission problem and honestly I wouldn't worry to much about it, unless you have too. Why do you care about accessing the reports via the console?
  9. GarthMJ
    This would have to be a very custom script to do this and there is no simple way to do this. Honestly why would you care about who the owner is of each exe? Most, if not all exe will be owned by Local System, particularly if the exe are installed using an MSI. What is you end goal?
  10. GarthMJ
    How exactly did you setup SSRS?
  11. GarthMJ
    I would re-install your reporting point.
  12. GarthMJ
    It happens, the only solution is to force a full inventory. BTW I strongly recommend changing your SW to 14 days. My laptop with and SSD take ~4 hour to run and I’m not inventorying much. http://be.enhansoft.com/post/2013/10/03/Slow-Software-Inventory-Cycle-in-SCCM-2012.aspx
  13. GarthMJ
    The easiest way to fix this is to force a full hardware scan of the affected PCs. I recommend set HW in to daily. I also recommend turning OFF SW inventory or at least making it every 14 days. IMO it has little value.
  14. GarthMJ
    I asked about the web interface not query designer. Did you also enable the remote errors, as per the blog?
  15. GarthMJ
    Query or Reports. They are completely different. Query = Collections = WQL; Reports = SSRS = SQL This will help you will a report. http://smsug.ca/blogs/garth_jones/archive/2012/03/11/link-to-name.aspx
  16. GarthMJ
    There are several options. HTLM page and embedded the Report. Setup a file subscription http://be.enhansoft.com/post/2013/08/27/How-to-Set-up-a-Windows-File-Share-Subscription.aspx
  17. GarthMJ
    Does this report work in the Web SSRS interface? Also see this blog post to enable remote error reporting. http://be.enhansoft.com/post/2013/01/16/Enabling-Remote-Errors-in-SQL.aspx
  18. GarthMJ
    Have you enabled all of the AI classes to be inventoried?
  19. GarthMJ
    Hardware inventory will be what updated this info. Set your HW inv to daily.
  20. GarthMJ
    Keep in mind that query will only find x86 version of Office 365. You need to add the x64 class too if you want both x86 and x64.
  21. GarthMJ
    Enable the win32_printer class within hardware inventory to get local printer.
  22. GarthMJ
    This report query will help you out. http://smsug.ca/blogs/garth_jones/archive/2012/07/02/how-to-find-an-application-installed-in-the-last-7-days.aspx
  23. GarthMJ
    Replace 'ES-06' with @PC This will create a prompt for the report. If you want to make it fancy you can then add a drop down or browse list for the PC name. The easiest way to convert your CM07 to CM12 report is to make sure that you have already converted them from ASP to SSRS then you can upload the same converted reports to CM12. Other than that, I your recommend rebuilding them and filtering out all the old junky reports.
  24. GarthMJ
    Yes, you can do that you will need to open the report and edit SQL to do it. I would recommend that make your own version of that report, instead of replacing it.
  25. GarthMJ
    It is not possible to run CM12 with any other collation and you want you temp db to be the same collation too. As an aside I NEVER recommend that SQL be remote from CM12.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.