To display fields stating "file missing" in Splunk DB query output

[prajwal_94]

Hi 

Could someone help to let me know how to display fields stating "file is missing" in Splunk DB query output when no output is expected

Currently the below query returns-

| dbxquery query=" select * from ............................ ;"
connection="to_connect"

> No results found

Expected output-
file missing   file missing    file missing
(if possible ...different texts in different columns, not sure if eval/fillnull command can be used here)

[prajwal_94]

Hi Team,

Could someone please help here