Hi Ann,

A bit curious on why you are looking for the numbers. Just a one-off, or would you run this 'count' weekly, monthly, yearly, etc. Any numbers you are interested in as it could inspire/enrich our statistics epic.

Genericly I can answer the below, remember that a database of 1 gigabyte acts differently than a 2 terrabyte one,...

• Last run of DatabaseUpgradeTool/DBUT holds rough counts from your system. These rough numbers help to analyze upgrade issues as all customer databases are growing forever, however the product still needs to do conversion at times (on that growing data). Typically on the server in \InfoShare\App\Setup\DBUpgradeTool\ where the line you are interested in looks like "ContentObjects: 50473 [deleted:0]"
• A one-off database query, however we offer no guarantees on the database structure across product versions, it is NOT an API. Plus long-running database queries are known to cause locking issues in the application, so the timing of running them matters.
• ISHRemote (of course :-)) which relies on API calls, but is of course relatively slow as you are in essence iterating the whole Folder Structure, respecting business and security logic all the time. We don't have some counter readily available for you. The starting structure would look like below

$imageCount = 0
$xmlCount = 0
Get-IshFolder -FolderPath "General\Myfolder" -FolderTypeFilter @("ISHIllustration", "ISHModule", "ISHMasterDoc", "ISHLibrary") -Recurse | 
Get-IshFolderContent -VersionFilter "" | 
ForEach-Object -Process { 
  if ($_.IshType -in @("ISHIllustration")) { ++$imageCount }
  if ($_.IshType -in @("ISHModule", "ISHMasterDoc", "ISHLibrary")) { ++$xmlCount }
}
Write-Host ("imageCount["+$imageCount+"]")
Write-Host ("xmlCount["+$xmlCount+"]")

Best wishes,
Dave

Hi Ann,

A bit curious on why you are looking for the numbers. Just a one-off, or would you run this 'count' weekly, monthly, yearly, etc. Any numbers you are interested in as it could inspire/enrich our statistics epic.

Genericly I can answer the below, remember that a database of 1 gigabyte acts differently than a 2 terrabyte one,...

• Last run of DatabaseUpgradeTool/DBUT holds rough counts from your system. These rough numbers help to analyze upgrade issues as all customer databases are growing forever, however the product still needs to do conversion at times (on that growing data). Typically on the server in \InfoShare\App\Setup\DBUpgradeTool\ where the line you are interested in looks like "ContentObjects: 50473 [deleted:0]"
• A one-off database query, however we offer no guarantees on the database structure across product versions, it is NOT an API. Plus long-running database queries are known to cause locking issues in the application, so the timing of running them matters.
• ISHRemote (of course :-)) which relies on API calls, but is of course relatively slow as you are in essence iterating the whole Folder Structure, respecting business and security logic all the time. We don't have some counter readily available for you. The starting structure would look like below

$imageCount = 0
$xmlCount = 0
Get-IshFolder -FolderPath "General\Myfolder" -FolderTypeFilter @("ISHIllustration", "ISHModule", "ISHMasterDoc", "ISHLibrary") -Recurse | 
Get-IshFolderContent -VersionFilter "" | 
ForEach-Object -Process { 
  if ($_.IshType -in @("ISHIllustration")) { ++$imageCount }
  if ($_.IshType -in @("ISHModule", "ISHMasterDoc", "ISHLibrary")) { ++$xmlCount }
}
Write-Host ("imageCount["+$imageCount+"]")
Write-Host ("xmlCount["+$xmlCount+"]")

Best wishes,
Dave