Forum Discussion

Jolo_SG's avatar
Jolo_SG
Regular Visitor
3 years ago

How do I flag Compliant vs. Noncompliant Software Versions?

Hi all,
I am new to Power BI and I am racking my brain trying to figure this out.
I am responsible for reporting software versions compliance (meaning that it is up to date/patched/current/etc...).

I am pulling a managed device and application data with PowerShell Graph for Endpoint Reporting, basically I can see what application versions are installed on which systems. (see pics)

 

My problem is that only two versions are up to date and the rest are not. I would like to be able to create a checkbox for each version that will let me confirm if a version is compliant or not.

It doesn't have to be a check box, but some way to quickly flag a version True/False or Yes/No, Good/Bad, etc...

The goal would be to have a new chart that shows all the versions of an application installed on our managed computers. Then be able to select which versions are compliant (like a slicer maybe?), and have the chart show what percentage of the installed applications are up to date.

I really want avoid having to go into Transform Data and create duplicate columns and then put the complaint versions in one and the noncompliant in another, and then repeat all that work every time one of 20 different applications gets updated across 800+ computers in the report. 

I may be asking the for the wrong thing in the question or drastically overcomplicating something. I have tried seaching forums, articles, tutorials, Youtube, etc... and I can't find anything like what I am looking for. I can't even find someone asking the same questions which tells me I may be looking at this wrong in the first place. I'm really feeling the "I don't know what I don't know right now". 

Any help would be much appreciated.

 

Thanks,

-Jonathan 

9 Replies

    • Jolo_SG's avatar
      Jolo_SG
      Regular Visitor

      Hey lbendlin,

      Thanks, I will need to get permisson from Security before I can do that. They may have me edit some sensitive information, but I don't think that will cause problems with the sample data.

       

  • You can perhaps use "New Group" to but the different Version in groups. Right klick the version column: NEW Group, choose list.

  • Jolo_SG's avatar
    Jolo_SG
    Regular Visitor
    deviceNamedisplayNameid.1version
    QTSQATERMINAL3Mozilla Firefox (x64 en-US)0000d26324c7fd7e8c7705daded5ecc9931a0000ffff103
    2T8FTG3-HQLMozilla Firefox (x64 en-US)00009a377e65ef971c6a7883cb88be0f7ae20000ffff106.0.1
    6CMGMQ2-HQLMozilla Firefox (x64 en-US)00002e8725f72ffacf784e7b9898e32335660000ffff107.0.1
    HNKX9K3-HQLMozilla Firefox (x64 en-US)00002e8725f72ffacf784e7b9898e32335660000ffff107.0.1
    PF3ZH1LJ-HQLMozilla Firefox (x64 en-US)00002e8725f72ffacf784e7b9898e32335660000ffff107.0.1
    1QCFTG3-HQLMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    24XSTN2-HQLMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    3ZWRQ73-HQLMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    5PDLXT2-HQL5Mozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    B19FTG3-HQLMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    C8D2ZW2-HQLMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    CQDFN73-HQLMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    H0PK5S2-CALMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    J06Y0J3-CALMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    JMHKWT2-CALMozilla Firefox (x64 en-US)000055a4971adb6359e6919f5b8d0fcc23250000ffff108
    2HP1Q73-RMLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    5SQP5S2-HQLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    6BPDX33-HQLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    6ZPGN13-HQLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    C61FX33-RMLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    FCFRYW2-HQLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    R90VFVTK-HQLMozilla Firefox (x64 en-US)0000ca0169d7b9bbcfa4e65eb68a13f930210000ffff108.0.1
    2NWSWT2-HQLMozilla Firefox (x64 en-US)0000259ee4f7aa982814b4cddc4c0df250690000ffff108.0.2
    D3D2ZW2-HQLMozilla Firefox (x64 en-US)0000259ee4f7aa982814b4cddc4c0df250690000ffff108.0.2
    DQX6VN2-HQLMozilla Firefox (x64 en-US)0000259ee4f7aa982814b4cddc4c0df250690000ffff108.0.2
    F3LJ3F3-HQLMozilla Firefox (x64 en-US)00007f403aab0b5c26affbdbe474f5ea4c240000ffff109
    G7VF3F3-RMLMozilla Firefox (x64 en-US)00007f403aab0b5c26affbdbe474f5ea4c240000ffff109
    4G4H793-HQLMozilla Firefox (x64 en-US)00006e1df073188511062abb53d365122aa00000ffff109.0.1
    3YDFN73-HQLMozilla Firefox (x64 en-US)0000917e3587c4107a96e9c0b0803231bdcd0000ffff110
    54JTQC2-HQLMozilla Firefox (x64 en-US)0000917e3587c4107a96e9c0b0803231bdcd0000ffff110
    F6FN793-RMLMozilla Firefox (x64 en-US)0000917e3587c4107a96e9c0b0803231bdcd0000ffff110
    G36ZTT3-HQLMozilla Firefox (x64 en-US)0000917e3587c4107a96e9c0b0803231bdcd0000ffff110
    CG7NQ13-HQLMozilla Firefox (x64 en-US)0000ec6a6ec3e37cb4457dabc7474dc98f340000ffff110.0.1
    1SCFTG3-HQLMozilla Firefox (x64 en-US)00000b2f6d20489ce0d82fceac74635595750000ffff111
    209FTG3-HQLMozilla Firefox (x64 en-US)00000b2f6d20489ce0d82fceac74635595750000ffff111
    42BKWT2-HQLMozilla Firefox (x64 en-US)00000b2f6d20489ce0d82fceac74635595750000ffff111
    94FWQN2-HQLMozilla Firefox (x64 en-US)00000b2f6d20489ce0d82fceac74635595750000ffff111
    FRCFTG3-HQLMozilla Firefox (x64 en-US)00000b2f6d20489ce0d82fceac74635595750000ffff111
    BK989K3-HQLMozilla Firefox (x64 en-US)00006aae3660b021e2079de9cf670e254df00000ffff111.0.1
    D1D2ZW2-HQLMozilla Firefox (x64 en-US)00006aae3660b021e2079de9cf670e254df00000ffff111.0.1
    10JDX33-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    119FTG3-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    169H0J3-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    174T3J3-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    182GFG3-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    182YW33-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    18GCM33-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    191FX33-HQLMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    1H7RF13-CALMozilla Firefox (x64 en-US)0000f1f63cd9d49ba4820083fd4018c49dc20000ffff91.0.2
    • andhiii079845's avatar
      andhiii079845
      Icon for Solution Sage rankSolution Sage

      I would prefer that you create only a table with the current compliant Version of the different software.

      You can than create a easier mapping what is compliant and not. You can also buid this table in excel and import it in the report.

  • Jolo_SG's avatar
    Jolo_SG
    Regular Visitor

    This is an sample.
    There are multiple versions of Firefox installed.
    This is pulled from 800+ systems every day and compiled in Power BI to show Application Version Changes over time. 
    I'd like to be able to find a way to flag certain version numbers as Compliant or Non-Compliant without having to manually enter that information into a cell for every version, on every system, for every date. 

    This is what my report looks like right now.

    The compliance score I have is a text box that is manually calculated everytime I update the report. 

    I'd like to be able to use the Version box (Slicer) on the bottom right to click which versions out of all of them are good and then have it calculate a compliance score automatically. (I am aware that using a slicer is probably the wrong way to do this, but I can't really think of another interface that will let me make selections)

     

    -Thanks 🙂

    • andhiii079845's avatar
      andhiii079845
      Icon for Solution Sage rankSolution Sage

      You can make a dimensional table only for the current complaint version of the different software. and every other version is non complaint. Can you perhaps show only some data from the involved tables please with the column names? 

      • Jolo_SG's avatar
        Jolo_SG
        Regular Visitor

        Every Time I try and copy and past Table data it dissappears.