[Spacewalk-list] monitoring repo cache rebuild date

[Miroslav Suchy]

Dne 11.10.2011 17:47, Josh.Mullis at cox.com napsal(a):
> Does anyone know which database table contains the “last repo build” date?
>

Good start is browsing through documentation:
http://spacewalk.redhat.com/documentation/schema-doc/

But it does not seem to get result in this case.

Looking at jsp it is stored in variable repo_last_build.
struts-config.xml then point me to:
code/src/com/redhat/rhn/frontend/action/channel/ChannelDetailsAction.java
where is this variable bind to value of 
ChannelManager.getRepoLastBuild(chan)

and getRepoLastBuild is defined as (abbreviated):
File theFile = new File(mountPoint + File.separator + pathPrefix +
                 File.separator + channel.getLabel() + File.separator +
                 "repomd.xml");
Date fileModifiedDateIn = new Date(theFile.lastModified());
return 
LocalizationService.getInstance().formatCustomDate(fileModifiedDateIn);

So back to your question. This value is not taken from database. It is 
read as modification time from repomd.xml file.

I hope it will help you.

Mirek Suchy