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
    Just keep in mind that you can't query for both x86 and x64 within the same query. You will need to use sub select queries or you can use two different queries fro the collections.
  2. GarthMJ
    This will do what you want. Select * from v_FullCollectionMembership_valid FCMV join v_FullCollectionMembership_valid FCMV2 on FCMV.ResourceID = FCMV2.ResourceID Where FCMV.collectionid = @Var1 and FCMV2.collectionid = @Var2 I know this is a bit self promo but IMO this is a great book. :-) https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/
  3. GarthMJ
    Are you taking about just two collection or more than two. BTW I don't recommend using Report build to create reports, instead us SQL Server Data Tools. It can do more than RB.
  4. GarthMJ
    You are only querying the x86 software titles. You need to use the x64 view to get the x64 SW titles.
  5. GarthMJ
    The %computername% will not do what you want as it will always be the site server. You should use an domain account.
  6. GarthMJ
    Yes this is still true in CM12 and CMCB. The simple fix is to always all content to be downloaded on slow boundaries. You sett this one each package, application, SU, etc.
  7. GarthMJ
    No there is a folder that was created with the backup takes that includes all the correct files. It is called cd.latest
  8. GarthMJ
    The log show that the client was successfully installed. Check our boundaries.
  9. GarthMJ
    What do you mean you have SQL Express 2008? It is not supported so....
  10. GarthMJ
    It looks like that installed was successful, why do you think it failed?
  11. GarthMJ
    There is not going to be a hard and fast steps for this. You will need to review your IIS setup, eventviewer and server environment to determine why it is getting overloaded. Is it the network or RAM or SQL or etc...
  12. GarthMJ
    Error Massage 0x80244022 = Same as HTTP status 503 - the service is temporarily overloaded.
  13. GarthMJ
    Have you run this setup manually as the local system account?
  14. GarthMJ
    Hi Owen, there are lots of examples on the web, what don't you like about them? There is at least one of link is on WN site too. https://www.windows-noob.com/forums/topic/3479-find-which-server-is-virtual-and-which-is-physical/
  15. GarthMJ
    I haven't had time to do testing but I'm willing to bet it is related to SSRS 2016.
  16. GarthMJ
    1. SW Metering will only work if you create rules for each SW title. Generally most people have a few at best. 3. without looking at the app it is hard to say what is the best way to manage it. Honestly you should talk to the vendor and ask them. And if their answer is to scan the file. You should tell them this is NOT a good options and they should work on creating a better option for enterprise environment. 4.2 This will have no effect on anything that is not using SW inv. 4.3 only 3rd party software is the only other option.
  17. GarthMJ
    Why do you think that? I never recommend using Software Inventory (SW) as it is just too unreliable and there are too many good alternatives such as HW and AI data. Heck even CI will do a better job of this, it does mean work on your part but...... Please provide an example. Are you SURE that it is not listed within ARP? Very, very, very little doesn't add an entry into ARP, most exe are a wrapper for MSI, and all MSI are listed within ARP. Honestly there isn't much you can do, you can submit these SW titles to AI for them to normalize but I wouldn't hold my breath that it happen soon. You can also look at 3rd party software to do this but it will cost $$s.
  18. GarthMJ
    Have you tried to do this from the SSRS website instead of within CM console? What version of SQL (SSRS) are you running? Did you know that there is less overhead access report via the web interface than via the CM console?
  19. GarthMJ
    The error tells you what the problem is. there is not object called managementpackdim for the dataset listed.
  20. GarthMJ
    No there is not and it doesn’t make sense to create a report for this too. Why you ask because there is an ave of 186 items in ARP per computer. With 60 computer that would be 186*60= 11,160 rows of data. Or 11,160/80 = 140 pages of text! There is no way anyone will ever read this report. Instead you should look at Software 01A - Summary of installed software in a specific collection and use those results for your needs. I’m sure that you can write a script to export a cvs or excel sheet but I’m also fairly sure that you can export 60 items faster than writing the script too. BTW, if you really want to do this this is more of a SSRS powershell question than a CM question.
  21. GarthMJ
    The policy will get refreshed at the next policy cycle. aka every 60 minutes by default. Or to can manually force the download computer policy
  22. GarthMJ

    SCCM MAC address report

    GarthMJ replied to kesh's question in Reports

    Because you didn't tell the query to limit to a collection. Look at my blog post link as your starting point.
  23. GarthMJ

    SCCM MAC address report

    GarthMJ replied to kesh's question in Reports

    No only will it duplication the data, it will give you old data. There are two network folders.. try them.
  24. GarthMJ
    You should do your testing as CM will deploy it. Therefore once you solve it using the psexec trick, it will work for CM too. https://verbalprocessor.com/2007/12/05/running-a-cmd-prompt-as-local-system/
  25. GarthMJ
    How exactly are you deploying this? With what settings?
×
×
  • 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.