[Koha] Regarding sql report for analytical records created

[Suresh Kumar Tejomurtula]

Hi,

I would like to get a report on analytical records created in koha.

The below is the query I tried, but getting a blank output. Iam very new to
sql reports. I tried looking in the sql reports library, but could not get
any.

SELECT biblio.biblionumber, biblio.title, biblio.author,

 ExtractValue(bi.marcxml,'//datafield[@tag="773"]/subfield[@code="0"]') AS
hostrecordnumber FROM biblio
LEFT JOIN biblioitems ON (biblio.biblionumber=biblioitems.biblionumber)
where
ExtractValue(bi.marcxml,'//datafield[@tag="773"]/subfield[@code="0"]') is
not null

-- 
Regards
T. Suresh Kumar