@cmerriman Hi..It works well ask per your comments but i can see it shows others private dashboards usage as well which I don't want because they can be used to test purpose which they will hit many times definitely... I need to check only the dashboards which are shared to all users.. i need to ignore the private dashboards which created by anyone...How to achieve this ... View more

@renjith.nair So i have copied that exactly as your search and replaced like this base search |eval "Coin Acceptor","Loyalty Scanner"=null() |foreach *[ eval "Coin Acceptor","Loyalty Scanner"=if(<>=="Unavailable"),if((isnull("Coin Acceptor","Loyalty Scanner"),"<>"),("Coin Acceptor","Loyalty Scanner"),"<>"),"Coin Acceptor","Loyalty Scanner"] | table Store,Lane,Lane_Status,"Coin Acceptor","Loyalty Scanner" But i am receiving this error "Error in 'eval' command: The arguments to the 'isnull' function are invalid. " Can you help me on this ... View more

@renjith.nair I have changed my query like this Base search *|eval "Coin Acceptor","Loyalty Scanner"=null() |foreach *[ eval "Coin Acceptor","Loyalty Scanner"=if(<>=="Unavailable"),if((isnull("Coin Acceptor","Loyalty Scanner"),"<>"),("Coin Acceptor","Loyalty Scanner"),"<>"),"Coin Acceptor","Loyalty Scanner"] | table Store,Lane,Lane_Status,"Coin Acceptor","Loyalty Scanner","Receipt Printer" but i am receiving a error like "Error in 'eval' command: The arguments to the 'if' function are invalid." So i the FIELD i give any particular thing or any random name...and in you have given as <> and "<>" is that correct or i have give double quotes in everywhere. ... View more

Actually there are many field in the data model in that I have many component if any one of the component becomes unavailable it status will be unavailable..I what to check all my component if any one or more becomes unavailable I want to display all those component which makes it unavailable I am receving like this Lane_Status Coin Acceptor Loyalty Scanner Receipt Printer Unavailable Unavailable Available Available Unavailable Available Unavailable Available But I need like this Lane Lane_Status Coin Acceptor Loyalty Scanner Receipt Printer 12 Unavailable Unavailable 13 Unavailable Unavailable ... View more