Trying to query a web app or site by modified date.
select * from site
where modified > 01/01/2013
Can this be done?
Yes you can. You'll need to use the Sharepoint API and query the scope(). Something like this:
<QueryText language="en-US" type="MSSQLFT">Select Size, Rank, Path, Title, Description, Write, Author FROM Scope() WHERE (("SCOPE"='MySearch')) ORDER BY "Write" DESC</QueryText>
<FieldRef Name="Write" />
<SupportedFormats Format="urn:Microsoft.Search.Response.Document.Document" />
I did run into issues however which I've documented here:
Mossman's Query tool was a great help in troubleshooting my issues.