If you want to specifically generate a list from entering in SQL formatted queries in TMS you can do this with the Alert Queue feature new to TMS 2010 R2.      In this instance you could create an alert “Objects without a current location” and put in  the below SQL.   This is just an option I want people to be aware of since it is new functionality. 

Thanks

There’s also the quick SQL query:

select objects.objectnumber from objects

inner join objcomponents on objects.objectid = objcomponents.objectid

where objcomponents.currentobjlocid = -1

If the SQL tab of TMS Advanced Query could be further developed so that SA’s could enter SQL commands like this, tricker queries would be much easier! No updates or inserts though, mind you…

Cheers

Just an fyi to anyone else that was interested in this—I just stumbled upon a previous post from Jeri Moxley and she used current location login id<>*. That came up with a more accurate result for me because I thought everything had a site, but it doesn’t.

Hey, Thanks for the tips

I went into db config manage tables/columns and unchecked the display as distinct list for the current location site. I was afraid that it would also remove this inquery assistant (because most users need a distinct list), but it kept it in the query assistant and just changed it in the advanced query. Perfect!

We are actually trying to figure out the exact same thing without success.

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Brian Kraft
Sent: Thursday, June 16, 2011 5:13 PM
To: [log in to unmask]
Subject: Re: no current location recorded

Hi Stephanie,

We recently cleaned these up in TMS.

This worked for us:
Advanced Search - Current Location - Site or Subsite not equal to *

Hope you get the results you are looking for.

Brian

--

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

This communication (including any attachments) is intended for the use of the  

intended recipient(s) only and may contain information that is confidential,  

privileged or legally protected. Any unauthorized use or dissemination of this  

communication is strictly prohibited. If you have received this communication  

in error, please immediately notify the sender by return e-mail message and  

delete all copies of the original communication. Thank you for your cooperation.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.