Hi kris99,
you can use last() in your stats http://docs.splunk.com/Documentation/Splunk/6.1.4/SearchReference/CommonStatsFunctions
something like this should do the job:
index=xx InMaintenanceMode=False
| dedup MachineName,RegistrationState
| eval avail=if(SessionState=="","t","f")
| eval unreg=if(RegistrationState=="Unregistered","t","f")
| stats count, last(eval(avail="t")) AS Available, last(eval(unreg="t")) AS Unregistered by SiteName,DesktopGroupName
hope this helps ...
cheers, MuS
... View more