The first approach is to open a web browser and got to the site settings page (Site Actions > Site Settings > Modify All Settings).
The second approach is against the databases. Open SQL Server Management Studio, Connect to the server, new query, run the following:
SELECT [VersionId]
,[Version]
,[Id]
,[UserName]
,[TimeStamp]
,[FinalizeTimeStamp]
,[Mode]
,[ModeStack]
,[Updates]
,[Notes]
FROM [SharePoint_Config].[dbo].[Versions]
WHERE VersionId = '00000000-0000-0000-0000-000000000000'
ORDER BY Id DESC
This returns :-
The top row is the latest version. The query is performed on the SharePoint Configuration database. If you have called this database something instead of "SharePoint_Config" change the query to reflect this.
You can also look at the versions for Content Databases, by changing the database name. For example: FROM WSS_Content_MySites.[dbo].[Versions]
WSS SP1:- Download
MOSS SP1:- Download
MOSS 2007 post SP1 hotfix KB941422
MOSS 2007 post SP1 hotfix KB941274
MOSS 2007 post SP1 hotfix KB948945
MOSS 2007 Infrastructure Update KB951695 & KB951297
MOSS 2007 Cumulative update KB956056 & KB956057
