Require SQL query for office installated on user device with version & bit

Question

Require SQL query for office installated on user device with version & bit

solved 0
Saurabh Sharma 2020-08-26T16:01:44+05:30 6 Answers 523 views Beginner
0

Answers ( 6 )

  2. Ankit Shukla
    0
    2020-08-28T09:23:16+05:30
    Reply

    This is some related to inverted comma’s in copying and pasting, can you check the single inverted commas are correct.

    See the below example

    https://snipboard.io/zbroT7.jpg

  4. nanda kumar
    0
    2020-08-28T09:00:00+05:30
    Reply

    Hi Ankit,

    I am sorry to interrupt.

    I just copied the above SQL query in sql data base but the below error popped up while executing it. pls suggest.

    Msg 102, Level 15, State 1, Line 2
    Incorrect syntax near ‘‘’.

  6. Ankit Shukla
    0
    2020-08-27T09:10:53+05:30
    Reply

    Use below query

    Select
    Distinct sys.Name0 as ‘MachineName’,
    sys.User_Name0 as ‘UserName’,
    sys.Operating_System_Name_and0 as ‘Operating System’,
    App.ARPDisplayName0 as ‘DisplayName’,
    App.ProductVersion0 as ‘Product Version’,
    case when App.ARPDisplayName0 like ‘Microsoft Office 365%’ then ‘Office 365’
    when (App.ARPDisplayName0 like ‘Microsoft Office Profess%2013%’ or App.ARPDisplayName0 like ‘Microsoft Office Standard 2013%’) then ‘Office 2013’
    when (App.ARPDisplayName0 like ‘Microsoft Office Profess%2010%’ or App.ARPDisplayName0 like ‘Microsoft Office Standars 2010%’) then ‘Office 2010’
    Else ‘Other Version’
    End as ‘Office Version Category’
    from V_R_System sys
    INNER JOIN v_GS_INSTALLED_SOFTWARE App ON sys.ResourceID = App.ResourceID
    Where App.ARPDisplayName0 like ‘Microsoft Office 365%’ or App.ARPDisplayName0 like ‘Microsoft Office Profes%’
    or App.ARPDisplayName0 like ‘Microsoft Office Standar%’
    order by sys.Name0, App.ProductVersion0

    Best answer
  8. Ankit Shukla
    0
    2020-08-26T21:59:20+05:30
    Reply

    The first RDL file doesn’t require hardware inventory changes, if this also doesn’t work for you let me know will share the SQL query

  10. Saurabh Sharma
    0
    2020-08-26T17:52:06+05:30
    Reply

    Hi Ankit,

    We can’t do any changes in hardware inventory without client approval.So I require SQL query for this.

  12. Ankit Shukla
    0
    2020-08-26T16:23:30+05:30
    Reply

Leave an answer

Sorry, you do not have permission to answer to this question .