The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
| |
|
Re: How to tell if a remote user is logged on to a remote DB and not the network DB
Posted: 27 Sep 06 4:55 PM
|
fiogf49gjkf0d Which version of SalesLogix?
There are many ways to tackle this beast. You can look at the database aliases. Network users typically login to "SALESLOGIX" while remotes use "SLXREMOTE" (though some versions match up).
You could look at a field inside the database to tell if it's a remote or not. "Select dbtype from systeminfo" will give you the field. A dbtype of 1 is the host and I believe 2 is a remote. I believe there's a third type for remote office but my memory is a little fuzzy.
There's also Application.BasicFunctions.GetAttachmentPath in 6.2.x. I believe it'll return the server path if you're a network user and C:\Documents and Settings\... if you're a remote but I may be wrong there.
The dbtype approach is probably best because it requires less hard-coded knowledge. It'll also work going back to at least 4.x, possibly even an earlier version. |
|
|
| |
|
Re: How to tell if a remote user is logged on to a remote DB and not the network DB
Posted: 28 Sep 06 4:19 AM
|
fiogf49gjkf0d I did it because I've created some views on the main DB, that are obviously not Sync'ed out to the remotes.
So, I've pushed out a "create view sql string" to all remotes, but, when I used recut a remote FORGETTING to create them the view again, I was having error messages, so opeing the tab I'm testing if I'm a remote and if the view does exists.
If not I'm giving a friendly msgbox 
Sub AXFormChange(Sender)
''----------------------------
'' TEST: AM I REMOTE?
dim dbType,strsql2,objrs2
if not isnull(getfield("DBTYPE","SYSTEMINFO","systeminfoid='PRIMARY'")) then
dbtype = getfield("DBTYPE","SYSTEMINFO","systeminfoid='PRIMARY'")
else
dbtype = ""
end if
if dbtype = 2 then
'is my custom view available?
strsql2 = "SELECT type " & _
"FROM dbo.sysobjects " & _
"WHERE (name = 'my_amazing_view') AND (type = 'V')"
set objrs2 = objSLXDB.GetNewRecordSet
objrs2.Open strsql2,objSLXDB.connection
if objrs2.recordcount <> 1 then
'msgbox "You cannot view this TAB on a remote database." & chr(10) & chr(13) & _
'"Please switch to SLX Network connection.", vbExclamation, "SalesLogix"
exit sub
end if
objrs2.close
set objrs2 = nothing
end if
''----------------------------
|
|
|
|
Re: How to tell if a remote user is logged on to a remote DB and not the network DB
Posted: 12 Oct 06 8:27 AM
|
fiogf49gjkf0d Ron,
This may be a bit elementary, but if you are on SLX 6.2 the easiest way is to look in the SalesLogix administrator in the users section in the REMOTE USERS tab. See if there is a green light next to the users name in question in the LOGIN column. This will tell you if the user is CURRENTLY logged into the SLX application database server directly. |
|
|
|
Re: How to tell if a remote user is logged on to a remote DB and not the network DB
Posted: 13 Oct 06 8:20 AM
|
fiogf49gjkf0d | ...if you are on SLX 6.2 the easiest way is to look in the SalesLogix administrator in the users section in the REMOTE USERS tab. See if there is a green light next to the users name in question in the LOGIN column. This will tell you if the user is CURRENTLY logged into the SLX application database server directly. |
|
Isn't the idea behind a remote user is they have a copy of the database that is DISCONNECTED from the main database. Its it own database and as such.. it is in no way connected to the main database.
The idea is that a REMOTE is capable of working offline (like on a plane, train or hotel room with NO network connection.) To me this makes it impossible for anyone logged into the main DB to know if the remote (aka disconnected) user is logged in and using the system.
Does this sound right or am I missing something?
John G. |
|
|
|
Re: How to tell if a remote user is logged on to a remote DB and not the network DB
Posted: 13 Oct 06 8:25 AM
|
fiogf49gjkf0d | I need a way to tell if a remote user is logged on to their remote database on their laptop and not on the server database |
|
Ok, reviewing the original question and based on my previous post the answer to this question is this.
If the administrator logged into the main database shows a remote user as logged in, then they are logged into the main database - not their remote database. If the Admin is showing a remote user as not logged in then you can be certain the remote user is not logged into the main database. You cannot know if they are logged into their remote database.
John G. |
|
|
|
Re: How to tell if a remote user is logged on to a remote DB and not the network DB
Posted: 13 Oct 06 3:57 PM
|
fiogf49gjkf0d Originally posted by John Gundrum
If the administrator logged into the main database shows a remote user as logged in, then they are logged into the main database - not their remote database. If the Admin is showing a remote user as not logged in then you can be certain the remote user is not logged into the main database. You cannot know if they are logged into their remote database. |
|
The real question wasn't addressed until the follow up post. He created SQL views that were only present on the host database. He wanted to make sure the customization checked the database to make sure it was NOT a remote. This could be done through client scripting.
Everything you say is correct regarding what I call login auditing, or determining exactly who is logged into SalesLogix. There's no sure way of knowing if a remote is logged into their database from the server's perspective. Using a database field to determine this may or may not be accurate, especially regarding users sync habits. You can only reliably know who is logged into the host database and even then the code to determine that exactly is only present in the Administrator application. |
|
|
|