13CLIENT_QUEUE100000001001|High3|E-mail000010List of users &$PHYS_DATE_DD_MM_YYYY_d#<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style type="text/css">
table, th, td
{
border: 1px solid black;
border-collapse: collapse;
border-spacing: 5px;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
</style>
<title>Users</title>
</head>
<body>
<strong>These users will have to change their password :</strong>
<br><br>
<table>
<tr>
<th>UserGroup</th><th>User</th><th>Client #</th><th>FirstName</th><th>SecondName</th><th>LastPasswordChange</th>
</tr>100000| |2221002|Average000000100000000:0010000000000SQLIC|TextSQL - internalFREI|Freely selected0100010240000SELECT Usergroup.OH_Name "Usergoup", UserID.OH_Name "User", UserID.OH_Client, USR_FIRSTNAME, USR_LASTNAME, USR_PWCHANGE
FROM OH Usergroup, OH UserID, USR, USRG
WHERE USRG_USR_Idnr=UserID.OH_Idnr
AND USRG_USG_Idnr=Usergroup.OH_Idnr
AND UserID.OH_Idnr=USRG_USR_Idnr
AND UserID.OH_Idnr=USR_OH_Idnr
AND UserID.OH_Deleteflag='0'
AND USR_PWCHANGE < getdate() - 30
ORDER BY 1, 2, 3;U04002751 Attention: There is a variable-replacement restriction in case of security limits (SQLVAR_SECURITY_LEVEL)!