Recent-activity field doesnt appear in the excel output

[RekhaVadukul]

hi - Im trying to extract dry-run data to show all objects without recent activity over 90 days but the exported data is missing this field.

This is my command -
cs_tools tools archiver identify --config xxx --recent-activity 90 --syncer excel://filepath=_archive_one_year.xlsx --dry-run

Can someone point me in the right direction to getting this data please. Thanks

[TS-Apratim]

Hey @RekhaVadukul,

• the archiver file has a column called "modified" which states the date on which the last activity occurred for that particular guid/tml/row. The value of this date will be before the 90 day period from the date you executed the CS Tools archiver command.

• To explicitly get the number of days when this activity occurred before today (or the date when you executed the archiver command), you can create a new column like : " today()-modified "

[RekhaVadukul]

1.6.3

[RekhaVadukul]

TS - Version 10.9.0.cl-65

[philipaldhous]

We are finding the command cs_tools tools archiver identify --config prod --recent-activity 90 --recent-modified 90 --syncer "excel://filepath=searchable.xlsx" --dry-run is returning GUIDs that have not been modified in the last 90 days, but have been viewed in the last 90 days

[TS-Apratim]

Got it. There were some archiver fixes in this version, 1.6.3.
Can you guys try reinstalling on the venv, using the command : curl -LsSf https://thoughtspot.github.io/cs_tools/install.py | python3 - --reinstall --beta dev, and then try running the archiver from this version again ? Please create A NEW CONFIG FILE on top of this reinstalled version.

[RekhaVadukul]

Thank you - that seems to have worked, we will get back if we find any issues.