Product Versions

This page is designed to help determine product versions from the database side.

Works

SELECT * FROM Works..VersionNumber ORDER BY VersionNumber DESC

Note: this is a query from a v11 system. v10 systems wont have all these entries.

The version you are on will be the highest entry in the VersionNumber field- in this case v11.1.6.154.

Other important fields are...

chMedcinSearch- tells the version of Medcin you are on. Medcin is delivered quarterly so you need to determine the quarter of your version by looking at the date (Q4 2008 in this example). If this doesn't match the release you believe to have, your Medcin Update SQL job most likely failed. Check its history in SQL Agent.

AHSOCD- (v11 Only) this DB is part of the Allscripts delivered content and gets updated from time to time.

CareGuide- (v11 Only) Indicates the version of CareGuide content that is currently in the system. This content is updated periodically. Newest content is delivered with new versions of v11 or can be updated in older v11 systems. If your Organization did not purchase CareGuides you will still have this DB, but you can ignore it.

(code)select * from Works..hotfix

Select * from IDXwf..Product

Start >> Control Panel >> Add Remove Programs >> IDX Web Framework 4.0.XXXXXXXX

Scan Server: [SCAN-INSTALL-DIRECTORY]\Server\ServicePack open ServicePackInfo.ini with notepad

[ServicePackInfo] Major=3 Minor=31 ServicePackID=XX ServicePackDate=XX/XX/20XX