Forum Discussion

ldoodle's avatar
ldoodle
Icon for Advisor rankAdvisor
3 months ago
Solved

Table style widget + values from PropertSource - possible?

Hi, I’m just fiddling now but I had a thought about exposing at least Windows resources Windows Update info. The only way I’ve been able to do this is with an Alert style widget, but it doesn’t look...
  • Mike_Moniz's avatar
    Mike_Moniz
    3 months ago

    Having tables support property columns is a popular request. I suggest submitting that as feedback to LM. I’m not sure how color bars would work for properties since they are not numbers but perhaps there is a way to implement something close.

    As a workaround, perhaps you can create a “Info” DataSource that reports the version as a number. Like perhaps remove all the dots after the first one and do some zero padding (so 1.9.1 → 1.09001). Without the padding 1.10.2 (1.102) will come before 1.9.1 (1.91).

    There are also some forum posts you might find that do hacky tricks to use the API to generate HTML table code which can be displayed by the Text widget.

Cole_McDonald's avatar
Cole_McDonald
Icon for Professor rankProfessor
3 months ago

For any complex reporting out of LM, I use the API.  The reports have limitations that make it difficult to pull the info needed in most cases we’re hoping to use them for, and the table widgets have even more limitations… creating output tables in powershell is my goto for these and usually only takes 15-20 minutes to make a new novel report given I’ve already written the code to pull devices, groups, datasources, etc… I fill variables with each pertinent piece, then conjoin the bits and pieces to create the output I need to hand off.  I then store that resulting data-munging script for later use. I’m hoping the UIv4 refresh of these widgets will address some of these issues.

For version number storage, I either use a version property I’ve defined:
<app1Name>:1.20.4500.2,<app2Name>:34.2.10.7,…

This allows me to keep a dataset that I can parse in powershell on the back end stored with a device.

My general code for that is in a:
… | select-object @{name=”app1Version”;expression={($_.customproperties | where name -match serialStore).value}}

From there, you split on the comma and search for the app name… split on the : and take the rightmost chunk:
$var.split(“:”)[-1]