Search results for query: *

I was able to get it working and providing json code below to help anyone with this issue in the future: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "span", "style": {...

Greetings, I am trying to auto-populate an email content to auto create an email. I am using Microsoft Lists (I am not a programmer). My employer only allows outlook office 365 to be used over the web so we are not using the local outlook which it if we were I was able to find a code to auto...

I see:(... Trying to understand which table I can get the user roles from to show up as shown from the system's front-end: As you can see below from the st.role table is where under the sf_name column it shows the user roles as above on the front-end system:

Attached the results from your query: Select sf_user_id From st_user Where sf_user_id NOT IN (Select sf_user_id From st_useraccount_roles)

Adding r.sf_role_id to the end of the Select statement still got me "null" values. Basically as shown below tables st_useraccount_roles and st_role have a matching PK named sf_role_id but from these two tables only table st_useraccount_roles have matching PK key from table st_user, so basically...

Thank you Andy, I ran your query and got 0 results, but if do and left join I get data but again the r.sf_name shows "null" values.

Thank your for your reply Ian, I am not quite sure if these tables have foreign key constraints. Basically the first 3 tables I can gather all data I am requesting, then when I try to gather data with the 4th table that's where the problem occurs. Below all 4 tables columns and and the id...

Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null" values... Basically sf_role_id PK is also at table st_useraccount_roles and tables st_user and st_useracount_roles have a matching PK named sf_user_id...

Greetings, I have below query which I am trying to get the last table named st_role column st_role.sf_name data but I am getting "null" values... Basically sf_role_id PK is also at table st_useraccount_roles and tables st_user and st_useracount_roles have a matching PK named sf_user_id...

Ended with below code: SELECT DATE_FORMAT(FROM_UNIXTIME(`LongValue` /1000), '%m/%d/%Y') AS `timestamp`, U.Login AS BOPID, U.UserName FROM opinio.OPS_UserAttribute A, opinio.OPS_User U WHERE A.UserId = U.UserId And A.AttributeName = 'last login' ORDER BY LongValue DESC Thank you everyone!

Thanks Andy, I did a research as you suggested and ended as (will as well do some edit as you suggested to have a better performance): Select DATE_FORMAT(FROM_UNIXTIME(`LongValue` /1000), '%m/%d/%Y') AS `timestamp`, (Select Login From opinio.OPS_User Where UserId =...

Thank you so much Andy! I went ahead and added another field from OPS_user table: SELECT FROM_UNIXTIME(`LongValue` /1000) AS `timestamp`, (Select Login From opinio.OPS_User Where UserId = opinio.OPS_UserAttribute.UserId) AS BOPID, (Select UserName From opinio.OPS_User Where UserId =...

samjim, Did a research on FROM_UNIXTIME showing null values and I got it working, basically because unix time is in seconds and data shows stored it in milliseconds requiring to divide by 1000: SELECT *, FROM_UNIXTIME(`LongValue` /1000) AS `timestamp` FROM opinio.OPS_UserAttribute WHERE...

How can I add to the Code the "Login" data coming from the "opinio.OPS_User" table as both "opinio.OPS_User" and "opinio.OPS_UserAttribute" tables have the unique column match "Userid" select Login, UserId from opinio.OPS_User

Thank you so much for the support! I ran below Code and I got many 1969 year date since "LongValue" was "0" which means user never logged in so no timestamp (that's ok)... then I changed order by to "DESC" and I can see "NULL" value under timestamp. As an example for 1 userid 10553 system shows...

Apologies, I thought since it is SQL I could request here.

When I run below Select statement to gather all column data from the OPS_UserAttribute table I can see the "last login" - I think what I need is to decipher the "StringValue" and\or the LongValue, BigTextValue real data as it shows Null on some but I can see data on LongValue column but that...

Hi Everyone, I had this thread on SQL Server forum and was told since I am using MySQL to ask for this request here: I am a newbie getting started with SQL and did some search online but so far have not been able to solve and gather the data I need. I need to get all users last login data so...

It states it is MySQL... All I need is to gather the users "Last Login" data so I may delete users which have not logged in for a long time...

Hi Everyone, I am a newbie getting started with SQL and did some search online but so far have not been able to solve and gather the data I need. I need to get all users last login data so I may then delete user accounts that not logged in for a long time as I have reached the max license...