Skip to content

GarthMJ

Moderators
  • Joined

  • Last visited

Everything posted by GarthMJ

  1. I asked about the web interface not query designer. Did you also enable the remote errors, as per the blog?
  2. 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
  3. 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
  4. 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
  5. Have you enabled all of the AI classes to be inventoried?
  6. Hardware inventory will be what updated this info. Set your HW inv to daily.
  7. 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.
  8. Enable the win32_printer class within hardware inventory to get local printer.
  9. 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
  10. 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.
  11. 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.
  12. 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.
  13. I generally agree with AdinE but if this is seriously only for 150 users/devices then I would think that you can do it one 1 box, assuming SCSM will allow you to install everything on 1 box.
  14. Create a report, I think that I missed that tidbit, did you copy the SQL certificate to you local PC? And just to close off the other bit, can you run report from your RPs?
  15. Where did you install the RP? Are you trying to access the site via the cluster or the one of the node of the cluster?
  16. There is no best practice either way, there is few note about performance on site with 100 000 device or more. However, from a management standpoint you will have far fewer support issues with SQL be local than with it being remote. Heck I add 15 days to any project where SQL is remote due to the complexity it add and the inevitable problem that will crop up over time.
  17. SSRS is not supported to be installed on a cluster. You can install SSRs on one or both node but each will be separate install of SSRS. In order to use CM12 RP you would need to install the RP on each node and access then via the node address not the cluster address. As an aside, I never recommend splitting SQL from the primary server.
  18. What is causing the reboot messages? Are you sure they are CM12 Messages and not something like Windows Update?
  19. You can do this with WSUS or CM07/CM12. Are you using CM07 orCM12?
  20. We are looking for your help! Help us about by take 2 minutes to complete this survey about SCCM reports. It will help us decide on what new reports to add to Enhance Web Reporting (EWR) and what new reports we will be giving away in the future. http://fluidsurveys.com/surveys/info-HZv/configmgr-ssrs-report-survey-sept-2013/
  21. Then you will NEVER be able to install any service pack using CM12 and SUP.
  22. Have you talked to the team at Flexera to see how they suggest you handle this issue? They are the best people to talk to about this.
  23. This should be an non issue as you are using the CM12 server for SSRS, just create the reporting role on the server and then use the real CM12 db for the source.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.