New view – Real IP address based on v_GS_NETWORK_ADAPTER_CONFIGURATION and calculated Subnet field (not a subnet Mask!!!)

  Another custom query and a function for me. Basically, IP address is a mutivalue property, and sometimes discovery finds supernets if it can’t figure out the subnet mask. That means, if you break your 10.0.0.0 subnet, it still assumes class A network, so under v_RA_System_IPAddresses and  v_RA_System_IPSubnets you’ll see 10.0.0.0 and 255.0.0.0, when actually it’s…

1

Modified Administrative Security > "Administrative users security assignments" report with effective rights

  One of most useful reports is Administrative Security > Administrative users security assignments. It shows you Configuration Manager administrative users with rights, assigned to them. The only problem with that report, is that it shows you only groups and users you added as directly as Administrative Users. But, for example, if you have NA\JDoe…

0

Computer Make / Model with Lenovo real models

After looking at a couple of reports / SQL queries for Lenovo models, I realized that they have some drawbacks. Lenovo stores its model in a different class, called Win32_ComputerSystemProduct and the name for the field is “Version”. So, for SCCM, we need to enable it in Inventory first, but we’re not going to get…

0