Configmgr Report For Depend Of MS Workplace Variations with Structure Sort 32bit And 64bit

Oleh | November 2, 2017

This weblog publish goes to be model three on the identical subject (report for MS workplace versions) however with different requirements.My earlier posts on ssrs report for depend of MS workplace variations and drilled report again to see consumer names and so on may have some limitations like they won’t offer you bit type(architecture) like 32bit or 64bit of workplace put in on the consumer. They merely get the depend of the MS workplace version put in after which drill down additional to get you the listing of consumer computer systems with workplace edition,version,its OS and hardware scan date info.

Both the variations with ssrs report will be discovered on https://gallery.technet.microsoft.com/office/SCCM-Configmgr-Report-for-2c36f1b9https://gallery.technet.microsoft.com/office/SCCM-Configmgr-2012-SSRS-c482cca2 and

https://support.microsoft.com/en-us/help/928516/description-of-product-code-guids-in-2007-office-suites-and-programs

After posting these 2 studies, weblog viewers ,TechNet gallery and in boards have requested to get bit kind (32bit or 64bit) data for the workplace product that’s put in on the client.

I have lot of requests /posts in my To-DO listing to weblog about ,however resulting from time limitations ,i can’t carry all them.

So for this requirement to get 32bit and 64bit for MS workplace ,i discovered microsoft article to determine if the MS workplace is 32bit or 64bit. https://support.microsoft.com/en-us/help/928516/description-of-product-code-guids-in-2007-office-suites-and-programs and it’s based mostly on the product code.

This product is that we use to uninstall any software program utilizing msiexec /x {productID} /x

Below is the screenshot from the help article .

image

From the product code ,twenty first character from left (substring(productID,21,1) ) will inform you whether it is 32bit or 64bit .

0 for x86

1 for x64

If you learn help article ,there are lot of different data like launch model (RTM,SP1,SP2 etc) ,launch kind (Volume,retail,trail) ,

This product ID is saved in several SQL views in CM database ,of which we’re going to make the most of v_Add_Remove_Programs. For extra details about SQL views in SCCM, please refer https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b

Following are the workplace editions are added into the report . When you have some other workplace editions which aren’t in beneath listing ,please edit the report and append it.

‘Microsoft Workplace Private 2007
‘Microsoft Workplace Skilled 2007
‘Microsoft Workplace Skilled 2007 Trial
‘Microsoft Workplace Skilled Hybrid 2007
‘Microsoft Workplace Skilled Plus 2007
‘Microsoft Workplace Skilled Plus 2007 (Beta)’
‘Microsoft Workplace Commonplace 2007
‘Microsoft Workplace Commonplace 2007 Trial
‘Microsoft Workplace Final 2007
‘Microsoft Workplace Enterprise 2007
‘Microsoft Workplace Final 2007
‘Microsoft Workplace Final 2007
‘Microsoft Workplace 2010
‘Microsoft Workplace Skilled Plus 2010
‘Microsoft Workplace Commonplace 2010
‘Microsoft Workplace Skilled 2010
‘Microsoft Workplace Residence and Pupil 2010
‘Microsoft Workplace Residence and Enterprise 2010
‘Microsoft Workplace Skilled Plus 2010 (Beta)’
‘Microsoft Workplace Starter 2010 – English
‘Microsoft Workplace 2013
‘Microsoft Workplace Skilled Plus 2013
‘Microsoft Workplace Commonplace 2013
‘Microsoft Workplace Skilled 2013
‘Microsoft Workplace Residence and Pupil 2013
‘Microsoft Workplace Residence and Enterprise 2013
‘Microsoft Workplace Skilled Plus 2013 (Beta)’
‘Microsoft Workplace Starter 2013 – English
‘Microsoft Workplace 2016
‘Microsoft Workplace Skilled Plus 2016
‘Microsoft Workplace Commonplace 2016
‘Microsoft Workplace Skilled 2016
‘Microsoft Workplace Residence and Pupil 2016
‘Microsoft Workplace Residence and Enterprise 2016
‘Microsoft Workplace Skilled Plus 2016 (Beta)’
‘Microsoft Workplace Starter 2016 – English

As traditional ,obtain the SSRS studies (rdl) recordsdata from Technet gallery tepat di sini ,add to your reporting folder in SCCM reports,change the information supply and run the report.

Output:

SNAGHTML2377b296

Linked report:

SNAGHTML23790def

This report helps RBA (role based mostly administration) functionality.

Note that, 2nd report (drilled report) can’t be run individually and to run that, it’s important to run the first report which is depend of workplace variations and drill to 2nd report.

SQL code and parameter values for dataset (RBA): The next data is on your data solely and no enter required from you to run this report.

DataSetAdminID:select dbo.fn_rbac_GetAdminIDsfromUserSIDs(@UserTokenSIDs) as UserSIDs

Parameter for UserTokenSIDs: General>Parameter visibility>Internal, default values>specify values>=SrsResources.UserIdentity.GetUserSIDs(User!UserID)
Parameter for UserSIDs:General>Parameter visibility>Internal, default values>Get values from a question and select DatasetAdminID

you can at all times edit the RDL recordsdata ,customise it.

Happy reporting!


Silahkan periksa ini pelayanan yang baik di: http://www.test-net.org/services/network-mask-calculator/ atau mengunjungi BEBAS PERKHIDMATAN menu

[Total: 0    Rata-rata: 0/5]

Siapa yang menyangka pada "Configmgr Report For Depend Of MS Workplace Variations with Structure Sort 32bit And 64bit

  1. ดอกไม้วันเกิด

    I’d like to thank you for the efforts you’ve put in penning this website.
    I’m hoping to see the same high-grade blog posts by you in the future as
    well. In truth, your creative writing abilities
    has encouraged me to get my own, personal blog now ;
    )

    Balas

Tinggalkan Balas

Alamat email anda tidak akan diterbitkan. Bidang-bidang yang perlu ditanda *