Count of different File types

[Daniel_Wattier]

Is there a query that can help me find out how many documents of a particular type have been imported into OnBase?

We have set up a couple of departments up with the OnBase Office integration and I want to run a query that shows me how many documents of the following type are in OnBase:  Word, Excel, Powerpoint and Outlook (.msg).

Any assistance is greatly appreciated.

Regards,

-Daniel

[Gabe_DiEugenio · Accepted solution]

I have used this in the past:

select COUNT(*), ft.filetypestr
from hsi.itemdatapage idp
join hsi.filetype ft on idp.filetypenum = ft.filetypenum
group by ft.filetypestr