Report based on Registry Keys

[WildPh]

Is there a way to produce a report, based on registry keys, where value and valuename can have different "value", e.g.
#1: Valuename: TunnelAddress Value: x.x.x.x
#2: Valuename: TunnelDesc Value: VPN Default
#3: Valuename: TunnelDevice Value: WAN Miniport (L2TP)
#4: Valuename: TunnelDUN Value: VPN Quarantine Tunnel

[WildPh]

Works fine now.
Thanks a lot

[Hemoco · Accepted solution]

Sure, should be something like this: not tested

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, reg1.Value As Tunneladdress, reg2.Value As Tunneldesc
From tblComputers Left Join
  (Select *                           
    From tblregistry
    Where tblregistry.Valuename = 'TunnelAddress') reg1 On reg1.Computername =
    tblComputers.Computername Left Join
  (Select *
    From tblregistry
    Where tblregistry.Valuename = 'TunnelDesc') reg2 On reg2.Computername =
    tblComputers.Computername

where reg2.value is not null

[WildPh]

Thanks a lot.
Now I'm getting all computers, whether or not they have a VPN client installed.
Can we add a filter with a where clause? Something like where Tunneldesc is not empty?

[Hemoco]

This is an example for 2 fields, you can add more:

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, reg1.Value As Tunneladdress, reg2.Value As Tunneldesc
From tblComputers Left Join
  (Select *                            
    From tblregistry
    Where tblregistry.Valuename = 'TunnelAddress') reg1 On reg1.Computername =
    tblComputers.Computername Left Join
  (Select *
    From tblregistry
    Where tblregistry.Valuename = 'TunnelDesc') reg2 On reg2.Computername =
    tblComputers.Computername